How to subtract two lowest minimum scores from list

[Guest]

I need a formula for excel that lets me subtract the two lowest scores from a
list of scores. For example - my list of scores is 2, 5, 10, 10, 10, 10, 10,
10, 9. I would like a formula that would subtract the 2 and 5. All I've
been able to do is subract one lowest or subtract the same lowest two times
(which is not what I want).

The scenario is: my students take quizzes all semester and get to drop their
two lowest scores at the end of the semester. They have about 20 scores;
therefore, a formula for this would be helpful.

I have microsoft office excel 2003.

Thank you

 

[Jim Rech]

Check out the Small function in Help.

--
Jim
|I need a formula for excel that lets me subtract the two lowest scores from
a
| list of scores. For example - my list of scores is 2, 5, 10, 10, 10, 10,
10,
| 10, 9. I would like a formula that would subtract the 2 and 5. All I've
| been able to do is subract one lowest or subtract the same lowest two
times
| (which is not what I want).
|
| The scenario is: my students take quizzes all semester and get to drop
their
| two lowest scores at the end of the semester. They have about 20 scores;
| therefore, a formula for this would be helpful.
|
| I have microsoft office excel 2003.
|
| Thank you

 

[L. Howard Kittle]

Try:

=SUM(A1:A20)-SUM(SMALL(A1:A20,{1,2}))

HTH
Regards,
Howard