Friday, February 20, 2015

yogi_Compute Row By Row Expense By Category For Week Numbers In Columns

             Google Spreadsheet   Post  #1898
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-20-2015
post by  Marc Tyrrell:!category-topic/docs/spreadsheets/gAXRXs2y91M
Date range for expenses by type
Hi Folks,

I'm trying to set up a form which will allow for daily input of expenses and will produce a weekly summation of expenses by type.  The early version of the form is available at .

What I want to do is have people enter their expenses using the form, which is recorded in the Form Response 1 tab, and use the Cumulative by week tab to create weekly summaries of the expense by type.

I am totally lost in trying to figure out how to do this!  If it was a database, I could, but not with sheets.  I would REALLY appreciate any suggestions anyone has!


Hi Chris,

Thanks - here you go.