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.
(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