How do I exclude multiple low values from a formula?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a worksheet in excel to calculate my students' grades.
I need to exclude the two lowest marks from the string of values. I know that
using MIN I can remove the single lowest value, but how do I remove multiple
low values?

ex.

(3+4+5+6+7)-(3+4)

3,4,5,6,7 are the grades and the formula subtracts the two lowest grades of
the series.
 
=sum(your range) - min(your range) - small(your range,2)

give you the sum ex lowest two

divede by count(your range) - 2 to get average if desire
 
Back
Top