Formula to find average of the best 2 of 3 scores

M

Melanie

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
 
B

BoniM

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.
 
P

Pete_UK

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top