## Thursday, January 23, 2014

### yogi_Compute The SUM of Lowest Four Numbers In Cells D6 to D15

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-22-2014
Hi,

I am trying to sum the 4 lowest numbers in a range (that are in a single column).

Conceptually, I am administering a golf league where the sum I am looking for is the total team score, consisting of the 4 lowest numbers of that team's single column.

I am having trouble in some way with the formula "=sum(small(D6:D15......." and how to reference the 4 lowest numbers.

---
Unfortunately I'm still having trouble.

I neglected to mention that in some cases, the lowest numbers can be negative.  (ie. "under par")

This link is to my sheet.
The cell highlighted red is my proposed formula cell.  (I manualy did the math, only populating the cell with my desired number, 63 in this case).
Yellow is the column range, that I am looking for the 4 lowest, including negative numbers, where of course -5 is lower than -2, for example.

The red cell should equal -63 in this case.

Thanks kindly,

Mike
------------------------------------------------------------------------------------------------------------------------------------------------------