Adding the 4 highest numbers from a set of 6

S

seasport

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
 
P

Peo Sjoblom

One way

=SUMPRODUCT(LARGE(A1:A6,ROW(INDIRECT("1:4"))))


Regards,

Peo Sjoblom
 
Top