Google Spreadsheet Post #1763
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-14-2014
post by Chris634:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/OV0cOVow1YQ)
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.
---
https://docs.google.com/forms/
https://docs.google.com/
---------------------------------------------------------------------------------------------------
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Sep-14-2014
post by Chris634:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/OV0cOVow1YQ)
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.
---
https://docs.google.com/forms/
https://docs.google.com/
---------------------------------------------------------------------------------------------------
No comments:
Post a Comment