Sunday, July 14, 2013

yogi_Sum Cells Of Column A Except For The Last Populated Cell

                                          Google Spreadsheet   Post  #1283
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 14, 2013
user Zack18 (http://productforums.google.com/forum/?zx=n821th1q4nl1#!category-topic/docs/spreadsheets/1dkj_owWhDA)
Sum all cells in range expect the last cell that isn't blank
Hello,

What formula should I write to sum all cells in a given range (A1:A13), except for the last cell in the range that isn't blank.  If, for example, cell A:10 is the last cell that isn't blank, then I only want to sum cells A1:A9 (although if A:11:A13 were summed too that wouldn't really matter because they'd be blank anyways).

Thanks in advance for your help,

Zack
------------------------------------------------------------------------------------------------------------------------------------------------