Google Sheets SUMIFS does not work

0
votes

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: 

=SUMIFS(C7:C100, $A7:$A100, ">(TODAY()-7)", $A7:$A100, "<=TODAY()")

Example page: https://docs.google.com/spreadsheets/d/1hfdSWX9bNkR1TeUKO1vnbSXT740D2-64Gi5smX0oB5A/edit?usp=sharing

1
google-sheets

1 Answers

2
votes

Try moving the calls to the TODAY() function outside of quotes.

=SUMIFS(C7:C100, $A7:$A100, ">"&(TODAY()-7), $A7:$A100, "<="&TODAY())