Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add the 9 highest numbers out of 12?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I add the 9 highest numbers out of 12?
Try the below with numbers in A1:A12
=SUM(LARGE(A1:A12,{1,2,3,4,5,6,7,8,9})) If this post helps click Yes --------------- Jacob Skaria "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? |
#3
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 |