Assuming the scores are in A1:A10, just use

=SUM(LARGE(A1:A10,{1,2,3,4}))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.

and then rank those values.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Nigel Greenwood" wrote in message
oups.com...
At our gliding (soaring) club we record club members' flights, scoring
them according to a complex formula based on handicap, distance,
height, etc. At the end of the season a grand total score is
calculated for each member by totalling his/her 4 best (ie
highest-scoring) flights. I'm looking for a way of automating this in
an Excel w/sheet.

Is there some way of combining the Rank() function with Database fns?
A complicating factor is the fact that a given pilot may have n flights
over the season, where 1 <= n <= 10, say.. Maybe a Subtotal() fn could
be used.

Before I reinvent the wheel, I'd be grateful for any suggestions.

Nigel