Calculate weekly and monthly total in spreadsheet

Question!

How to calculate weekly sum (sum of last 7 rows printed in 7th row) based on daily values, same question for monthly (based on weekly or daily). I have tried some formulas but they all failed.

enter image description here

(first column is date column, not in image)

P.S. sorry for "too localized" and "not constructive" I just don't know how to ask this differently



Answers

For weekly column

=IF(IFERROR(WEEKNUM(A2)=WEEKNUM(A1), FALSE), "",SUM(B2:B8))

for monthly column

=IF(IFERROR(MONTH(A2)=MONTH(A1), FALSE), "",SUMIF(A2:A33, "


For the week column, you can add a formula like =IF(WEEKDAY(A8)=7,sum(B2:B8),"") (to put the sum of the week on Sundays.

For the month column: =IF(MONTH(A2)

By : assylias


This video can help you solving your question :)
By: admin