Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to subtract two lowest minimum scores from list
Check out the Small function in Help.
-- Jim "chayrun" wrote in message ... |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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to subtract two lowest minimum scores from list
Try:
=SUM(A1:A20)-SUM(SMALL(A1:A20,{1,2})) HTH Regards, Howard "chayrun" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Scores of a Range Cells. Highest or lowest depending a parameter | Excel Worksheet Functions | |||
how do i remove 5 lowest scores? | Excel Discussion (Misc queries) | |||
How do I set up a formula to throw out the 2 lowest scores? | Excel Worksheet Functions | |||
how to pick the lowest 10 golf scores | Excel Programming | |||
Trying to sum a range and drop the lowest 2 scores | Excel Programming |