Thanks:  0
Likes:  0

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

1. 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?

2. Easiest without code:

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.

3. 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}))

User Tag List

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•