Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Adding the 4 highest numbers from a set of 6
I wish to select the best 4 scores out of a maximum of 6 and add them
together to produce a ranking based on that criteria, using XL 2003 |
#2
|
|||
|
|||
One way
=SUMPRODUCT(LARGE(A1:A6,ROW(INDIRECT("1:4")))) Regards, Peo Sjoblom "seasport" wrote: I wish to select the best 4 scores out of a maximum of 6 and add them together to produce a ranking based on that criteria, using XL 2003 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding numbers to current numbers | Excel Worksheet Functions | |||
Adding numbers in a column that have 3 decimal places | Excel Worksheet Functions | |||
problem with adding columns of numbers | Excel Worksheet Functions | |||
Excel Adding duplicated numbers together | Excel Discussion (Misc queries) | |||
adding only positive numbers | Excel Discussion (Misc queries) |