Thursday, January 23, 2014

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

                                          Google Spreadsheet   Post  #1494
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-22-2014
question by michaelabendroth (http://productforums.google.com/forum/?zx=vrs81mo04d67&usp=sheets_web#!mydiscussions/docs/FoMR-ILCf-M)
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.
 
Thanks in advance.
---
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
------------------------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment