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.



No comments:

Post a Comment