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)
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")
https://docs.google.com/ spreadsheet/ccc?key= 0AroHKqNgDYP7dGF0S25yLVotbENiV jItSWhIMkQ1X1E&usp=sharing
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