With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
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 MIwww.energyefficientbuild.com. Jan-22-2014 question by michaelabendroth (http://productforums.google.com/forum/?zx=vrs81mo04d67&usp=sheets_web#!mydiscussions/docs/FoMR-ILCf-M)
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")