View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chayrun chayrun is offline
external usenet poster
 
Posts: 2
Default How to subtract two lowest minimum scores from list

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