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,
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
------------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment