Monday, December 3, 2012

yogi_Compute Sum Of Last N Non Blank Entries (Text Or Numeric) In A Column Or A Row


                                          Google Spreadsheet   Post  #910
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Dec 3, 2012


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