Is it possible to sum only the 10 highest or lowest in a ran

[gcarson]

I have a question related to a golf “league”

We have about 125 regular weekly players. We would like to be able to quickly post weekly results which only reflect the sum of the best (lowest for golf) weekly scores for both 9 and 18 hole competitions.

Is there an easy way to accomplish this in Excel?

 

[Anne Troy]

Easiest without code:

Row one is headings.
Row two is first record.

Hit Data-Filter-Autofilter.

From the Score column, hit the dropdown and choose Top 10. At the bottom of that column, hit the Epsilon (the funny looking E on the toolbar) and hit enter.

 

[Aladin Akyurek]

On 2002-02-23 17:24, gcarson wrote:
I have a question related to a golf “league”

We have about 125 regular weekly players. We would like to be able to quickly post weekly results which only reflect the sum of the best (lowest for golf) weekly scores for both 9 and 18 hole competitions.

Is there an easy way to accomplish this in Excel?

To sum 10 smallest values, use:

=SUM(SMALL(A2:A60,{1,2,3,4,5,6,7,8,9,10}))

To sum 10 largest values, use:

=SUM(LARGE(A2:A60,{1,2,3,4,5,6,7,8,9,10}))