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

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))

Find more posts tagged with

Formulas

Sheet Summary

Accepted answers

All comments

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.