How to create a Sheet Summary for the last 7 days ?

Brendan Ginns

I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error

=COUNTIFS(Complete:Complete, "0", Created:Created, TODAY(-7))

Mike TV

@Brendan Ginns

Try this:

=COUNTIFS(Complete:Complete, "0", Created:Created, AND(@cell >= TODAY(-7), @cell <= TODAY(-1)))

This should work but if your column called Created is the created date and not the completed date that could be part of your problem. Also, if you want to include items completed today in this then at the end for TODAY(-1) change it to just TODAY()