The try this

=SUM(LARGE(A1:A10,ROW(INDIRECT("1:"&MIN(4,COUNT(A1 :A10))))))

and this really is an array formula.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Nigel Greenwood" wrote in message
ups.com...
Gary''s Student wrote:
Hi Nigel:

If a members scores are in A1 thru A10, then try:

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

Thanks for the speedy response, Bob & Gary.

This would be an excellent method if I knew that each member has 10
scores -- but a given member might have only 1 score, or maybe 6. I'd
like to design the w/sheet to be as general as possible, & avoid having
to type in new formulas each time for each member!

I noticed that if you filter a list one of the display options is "top
10": could I modify that in some way? It seems that if I filter on a
member's name, then select "top 4" to filter the scores, the top 4
refer to the entire (unfiltered) list, not just that member's scores.

Nigel