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

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

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

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