title: Calculate weekly and monthly total in spreadsheet
body: <p>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.</p>
  
  <p><img src="https://i.stack.imgur.com/UVAVS.png" alt="enter image description here"></p>
  
  <p>(first column is date column, not in image)</p>
  
  <p>P.S. sorry for "too localized" and "not constructive" I just don't know how to ask this differently</p>