Google Spreadsheet Post #910
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec 3, 2012
user laakkus said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cugQOp_Hrqc)
How to get the sum of last 5 not empty cells in a column in google spreadsheets?
Hello.
UPDATED ON MAR-08-2013 to include solution for entries in a row
user laakkus said:(http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/cugQOp_Hrqc)
How to get the sum of last 5 not empty cells in a column in google spreadsheets?
Hello.
I'm quite new with google spreadsheet, more of a excel-guy..
Tried to Google a little but didn't quite find what I was looking for. So how is it done? And thanks in advance ;).
--------------------------------------------------------------------------------------
In the following solution to a bit more generalized problem I have assumed that the 5 last non blank entries may be TEXT or NUMERIc
