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