Friday, January 4, 2013

yogi_Compute Net Income Row By Row For Dates And Show It Only Once For Every Date


                                          Google Spreadsheet   Post  #954
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 05, 2013
user SampMan87  said:(http://productforums.google.com/forum/?zx=ey3zne3xqlhg#!category-topic/docs/spreadsheets/NoilMhG_pfQ)
How do I SUM data from a variable number of rows?
I am using Sheets in Google Chrome on Mac OS 10.7

I manage the funding for my band and I'm trying to improve transparency for the other member. We have a cashflow report that I periodically update when we make/spend money. I've been including daily totals since the beginning of time, that generally follow the formula:

=SUM(G4,C5:C8)-SUM(D5:D8)

where G4 would represent yesterday's daily total, column C would be specifically income, and column D would be specifically expenses. This kind of information I expect will help us keep track of how our funding grows, based on how we're making money and how we're spending it.

Now, each day may have any number of transactions taking place. For example, if there's a show that day, there'll be an entry for our cut of the door, any merch we sell, as well as expenses such as gas and paying out other bands. Other days may only have one transaction, for example if the drummer sells a CD to a coworker.

All that being said, my question is this: Is there a way to develop a single formula that will be able to detect the number of transactions in a day (possibly by the date stamp or the number of empty cells between today's and yesterday's totals), and adjust the range of the formula to reflect that number? Any information will be much appreciated. I've also included a link for an example of what the spreadsheet looks like.

---------------------------------------------------------------------------------------------------
following is a solution to the problem