title: Google Sheets SUMIFS does not work
body: <p>can't get SUMIFS with dates to work properly.
  I have a sheet with amount of daily exercise rep count and a cell on top with weekly average. But the average does not work.
  average formula looks like this: </p>
  
  <pre><code>=SUMIFS(C7:C100, $A7:$A100, "&gt;(TODAY()-7)", $A7:$A100, "&lt;=TODAY()")
  </code></pre>
  
  <p>Example page: <a href="https://docs.google.com/spreadsheets/d/1hfdSWX9bNkR1TeUKO1vnbSXT740D2-64Gi5smX0oB5A/edit?usp=sharing" rel="nofollow">https://docs.google.com/spreadsheets/d/1hfdSWX9bNkR1TeUKO1vnbSXT740D2-64Gi5smX0oB5A/edit?usp=sharing</a></p>