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    Jan 18, 2013
user david.vlk said:(!category-topic/docs/spreadsheets/38atDnOdNI8)
Count incomes for each office and total them on another sheet (example sheet attached)

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