How do I exclude multiple low values from a formula?

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

duane

=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
 

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