Saturday, January 19, 2013

yogi_From Data In Sheet1 Compute Income For Each Office Total By Month And Between Specified Dates


                                          Google Spreadsheet  Post  #981
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Jan 18, 2013
user david.vlk said:(http://productforums.google.com/forum/?zx=soh9zupgmep1#!category-topic/docs/spreadsheets/38atDnOdNI8)
Count incomes for each office and total them on another sheet (example sheet attached) 
https://docs.google.com/spreadsheet/ccc?key=0AkXOKcDKgvg0dE9QQlRzaDhwNDVOM05iQ3lpTEFzVFE#gid=0

Lets say I have 200 offices and 20 payments a day. I need to count incomes for each office, for all offices and for specified period (monthly, for dates selected, yearly). I can not copy and paste data for every payment added.  Every payment means a newly added row to the document.

Thank you.

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