ExcelBanter - Adding the 4 highest numbers from a set of 6

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Adding the 4 highest numbers from a set of 6 (https://www.excelbanter.com/excel-discussion-misc-queries/29207-adding-4-highest-numbers-set-6-a.html)

seasport

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

Peo Sjoblom

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

All times are GMT +1. The time now is 02:27 AM.