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     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/d/1WCcVe0bAUdBr1oxx695zHcnh_XrkvWRt2G66K5iRn4A/viewform?usp=send_form

https://docs.google.com/spreadsheets/d/1Bc7vBEWQlLMEqRps0iXAZw96bKaB9Oh8Juf9BfD7I_k/edit?usp=sharing

---------------------------------------------------------------------------------------------------


No comments:

Post a Comment