Calculate weekly and monthly total in spreadsheet


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


For weekly column


for monthly column


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