Is it possible to sum only the 10 highest or lowest in a ran
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

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

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Victoria, BC
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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. #2
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,581
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.
    ~Anne Troy

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,871
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

      
    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com