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    Dec 3, 2012

UPDATED ON MAR-08-2013 to include solution for entries in a row

user laakkus said:(!category-topic/docs/spreadsheets/cugQOp_Hrqc)
How to get the sum of last 5 not empty cells in a column in google spreadsheets? 

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