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
User Laakkus says: "Thank You!" that was fast.
ReplyDeleteYou Are Very Welcom Laakkus ... Now Let Us Keep Googling.
ReplyDeleteMake It A Great Day.
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
Hi, may I ask, whether it is possible to do the same function, but with the data in rows instead of columns (i.e. sum of last N non blank entries in Row A)?
ReplyDeleteThanks a lot!
Hi Vojtech:
ReplyDeleteI have added a sheet 'Entries In A Row' to enhance the solution to meet your requirement.
Make It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
That is perfect! Thank you very much!
ReplyDeleteYou Are Very Welcome Vojtech ... Now Let us keep Googling.
ReplyDeleteMake It A Great One
Cheers!
Yogi
Cloud Computing -- Google Docs Way
yogi--anand-consulting.blogspot.com
In this example it seems that the sum should be 21. The result seems to show the value of the 5th from the last non-empty cell?
ReplyDeleteI found the answer as it appears in another post http://yogi--anand-consulting.blogspot.com/2014/01/yogiin-new-google-sheets-compute-sum-of.html
ReplyDelete