MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula Help


Posted by Yates on September 22, 2000 3:18 PM

OK formula gurus, I have a row with 17 numbers all in separate cells. I need a formula that will let me subtract the lowest 3 numbers, but the numbers are not all different, some of the lowest 3 numbers can be the same ex. 15,15,12 or they may be all different. Does this make sense? Anyway, any help would be appreciated.
Thanks, Yates


Posted by Celia on September 22, 2000 5:30 PM


From what do you want to subtract the three lowest numbers? If you want to subtract them from the sum of the seventeen numbers :-

=SUM(A1:A17)-SMALL(A1:A17,1)-SMALL(A1:A17,2)-SMALL(A1:A17,3)

Celia