| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add the 9 highest numbers out of 12?
=SUMPRODUCT(LARGE(A1:A12,ROW(1:9)))
"Anchor" wrote: Each student gets to do 12 quizzes and only their best 9 scores will count towards their final grade. Is there a possible formula that can work out the 9 best scores out of the 12 in the range and then add them together? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average highest 16 numbers on a column of 32 numbers | Excel Worksheet Functions | |||
| How do I find the 12 highest numbers in a row of 52 numbers | Excel Worksheet Functions | |||
| Sum 3 highest numbers | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
| Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Hybrid Mode
