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     www.energyefficientbuild.com.   Feb-20-2015
post by  Marc Tyrrell:
https://productforums.google.com/forum/#!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 athttps://docs.google.com/a/cavara.co/spreadsheets/d/1qj1aGuh9UzmrEd3A3jKSSNJ3Iu6yyEaYnVekiQG-_B4/edit#gid=0 .

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!

Cheers,

Marc
---
Hi Chris,

Thanks - here you go.


Cheers,

Marc
----------------------------------------------------------------------------------------------------------------------------------------------