# Thread: Dropping 2 lowest scores (2002)

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

#### Posting Permissions

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