In Excel, how to select and then add up the best 6 scores out of 7

Discussion in 'Microsoft Excel Programming' started by Guest, Feb 26, 2006.

  1. Guest

    Guest Guest

    How do I set up a spreadsheet which will select and then add up the best six
    arithmetical scores out of 7? Any help would be appreciated.
    The version is Excel 2002 with SP3 running in Windows XP Home version.
     
    Guest, Feb 26, 2006
    #1
    1. Advertisements

  2. Guest

    Guest Guest

    Let's say you have the seven scores in column A and best is highest ( not
    like golf ), then in an un-used cell enter:


    =SUM(A1:A7)-MIN(A1:A7)
    --
    Gary's Student


    "Camashco" wrote:

    > How do I set up a spreadsheet which will select and then add up the best six
    > arithmetical scores out of 7? Any help would be appreciated.
    > The version is Excel 2002 with SP3 running in Windows XP Home version.
     
    Guest, Feb 26, 2006
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Leatherfoot

    Trying to sum a range and drop the lowest 2 scores

    Leatherfoot, Apr 2, 2004, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    246
    Frank Kabel
    Apr 2, 2004
  2. Gee

    Select Sheet then Select Range

    Gee, May 27, 2004, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    313
  3. Giselle

    Matching athletes and scores

    Giselle, Feb 12, 2006, in forum: Microsoft Excel Programming
    Replies:
    1
    Views:
    158
    Tom Ogilvy
    Feb 12, 2006
  4. Rob

    rank scores show ties and add top four scores

    Rob, Apr 6, 2009, in forum: Microsoft Excel Programming
    Replies:
    3
    Views:
    523
  5. Persson

    How to sum the 3 best scores for each country in a contest?

    Persson, Aug 7, 2009, in forum: Microsoft Excel Programming
    Replies:
    2
    Views:
    142
    Persson
    Aug 8, 2009
Loading...

Share This Page