If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula to find average of the best 2 of 3 scores
Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests
are out of 10. I would like to create a formula that takes the average of the best 2 or the 3 tests. How would I do that? Thanks |
#2
|
|||
|
|||
Formula to find average of the best 2 of 3 scores
Try this:
=AVERAGE(LARGE(A1:C1,{1,2})) -- Biff Microsoft Excel MVP "Melanie" wrote in message ... Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests are out of 10. I would like to create a formula that takes the average of the best 2 or the 3 tests. How would I do that? Thanks |
#3
|
|||
|
|||
Formula to find average of the best 2 of 3 scores
Here are a couple of ways:
Sums the range, subtracts the smallest value and then divides by two (assumes there will always be three values) =(SUM(C2:E2)-MIN(C2:E2))/2 Averages the highest and second highest values in the range (works even when there are only two values) =AVERAGE(MAX(C2:E2),LARGE(C2:E2,2)) These formulas are for grades entered in columns C, D, and E. Adjust as needed. "Melanie" wrote: Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests are out of 10. I would like to create a formula that takes the average of the best 2 or the 3 tests. How would I do that? Thanks |
#4
|
|||
|
|||
Formula to find average of the best 2 of 3 scores
Assuming your scores are in columns C, D and E starting on row 2, try
this: =(SUM(C2:E2)-MIN(C2:E2))/2 Copy down as required. Hope this helps. Pete On Nov 16, 7:08 pm, Melanie wrote: Hello, I have a spreadsheet that has test scores in 3 columns . All 3 tests are out of 10. I would like to create a formula that takes the average of the best 2 or the 3 tests. How would I do that? Thanks |
Thread Tools | |
Display Modes | |
|
|