Sunday, September 14, 2014

yogi_Formula In Cell B3 For Cells B3 To 3 To SumUp Expenses By Category For Each Month Of The Year

                      Google Spreadsheet   Post  #1763
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Sep-14-2014
post by Chris634:
I have a form the user is submitting dollar amounts for expenses on a variety of items.  As usual, each submission will populate and timestamp one row on the form responses sheet.

I need to create a second sheet that will show a sum of each expense (each column). But I want it to summarize by month, based on the timestamp if possible?  So for instance, If the user submitted multiple forms in September, I want the amount on the second sum sheet to reflect all the values that were submitted in September.  I will be doing this for each month.  So if it was submitted in October, the sum of that data will display in the October cells of the second sum sheet.