MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Adding columns


Posted by Kevan on October 08, 2001 7:46 PM

Hi Mrexcel

I have a column of 14 numbers. Below that I have the formula =sum(A1:A14), This of course adds all 14 numbers together.

My problem, I wish to eliminate the 2 lowest of these numbers, hence, I am only showing the total for the top 12 numbers.

If the lowest number is 1, and there are two number two's, I only want to eliminate one of the two's, and the one. Still leaving twelve numbers being added.

Thank you


Posted by Kevan on October 08, 2001 8:12 PM

Need formula help for said column

Posted by Travis Harr on October 08, 2001 8:13 PM

=SUM(A1:A14)-SMALL(A1:A14,1)-SMALL(A1:A14,2)

Posted by Kevan on October 08, 2001 8:24 PM

Thank you very much