Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Nov 2002
    Location
    USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dropping 2 lowest scores (2002)

    I have a list of 10 values across a row and am looking for a way to have excel eliminate or flag the 2 lowest values in the row as I want to sum the 8 higher values only. At the moment I am manually locating the 2 lowest values before performing my calculation. I Any suggestions...

    i.e. Mike 50 80 75 40 30 95

    I want to flag the 40 and the 30 and eliminate them from the sum

    Thanks,
    Steve

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Dropping 2 lowest scores (2002)

    If your 10 values values are in cells D1 through M1, the following equation will do what you want. Change the formula as needed.

    =SUM(D2:M2)-(SMALL(D2:M2,1)+SMALL(D2:M2,2))

    This takes the sum of all of the rows and then subtracts the lowest value and second lowest value. It does not matter what order the values are in. It even works if all numbers are the same. The equation may not work correctly with negative values.

    HTH
    Regards,

    Gary
    (It's been a while!)

Posting Permissions

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