Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: 4 columns, sum the 3 highest values

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Using Excel 2000

    I'm a college professor. I allow my students to take 4 tests but I only use the grades of the 3 tests on which they perform best.

    I have a spreadsheet set up with 4 columns of results (values from 0-100).

    I need excel to ignore the lowest grade and sum the three highest scores from each set of four columns into a new column that displays the total score out of 300.



    name test1 test2 test3 test4 total
    J.Doe 80 80 30 80 240



    thanks for any help you can give.
    i have a hundred students and doing this by hand is becoming tedious.


    Mike Maguire

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,655
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-05-09 11:51, mjmaguire wrote:
    Using Excel 2000

    I'm a college professor. I allow my students to take 4 tests but I only use the grades of the 3 tests on which they perform best.

    I have a spreadsheet set up with 4 columns of results (values from 0-100).

    I need excel to ignore the lowest grade and sum the three highest scores from each set of four columns into a new column that displays the total score out of 300.



    name test1 test2 test3 test4 total
    J.Doe 80 80 30 80 240



    thanks for any help you can give.
    i have a hundred students and doing this by hand is becoming tedious.


    Mike Maguire
    Something that I also compute!

    Lets say that the scores are in row in B1:E1 for Doe.

    In F1 enter:

    =IF(COUNT(B1:E1)>3,SUM(B1:E1)-MIN(B1:E1),SUM(B1:E1))

    and copy down for other students.

    I added the condition that you get a sum tout court, when there 3 or less scores are available.

    Aladin

    [ This Message was edited by: Aladin Akyurek on 2002-05-09 11:58 ]

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =SUM(LARGE(B1:E1,{1,2,3}))

    [ This Message was edited by: Mark W. on 2002-05-09 12:11 ]

  4. #4
    New Member
    Join Date
    May 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for your help.

Some videos you may like

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
  •