Monday, October 6, 2014

yogi_Compute Week By Week Total Of Columns B D And F

                  Google Spreadsheet   Post  #1782
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Oct-06-2014
post by  Jen-Lars:
(https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!category-topic/docs/spreadsheets/4qDFg3uUwJg)
How to sum data by week using google spreadsheet
I'm trying to add all the totals of "B", "D" and "F" and get a weekly total, for each week on this sheet.
I tried using this answer but the columns are different, and I can't figure out what to change.
Ideally I would get weekly totals each Sunday.
Columns are:


A
dates

B
daily expenses $

C

cumul. budget
D
daily subscribers
E
cumul. subscribers
F

daily $ avg
----------------------------------------------------------------------------------------