Formula in Sheet Summary returns different count result than filter

I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65).

In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) = WEEKNUMBER(TODAY())) and it's returning result B (68 in this case)

I've looked at the data from last week through today (which is a Tuesday and I can't account for the difference. Any ideas what is happening?

Find more posts tagged with

Formulas

Sheet Summary

Countif

Accepted answers

Paul Newcome

The week number for today is going to be different than the week number from last week. Your filter and formula don't match which is why the outputs don't match. You will need to either adjust your filter to only show rows created during this week number (which could show multiple years if you have multiple years in your sheet), or you will need to adjust your formula to look between those two specific dates to match your filter.

All comments

Paul Newcome

Liz W

I thought that might be it. Thank you - I'm off to search for new formulas!

Paul Newcome

Happy to help. 👍️

Liz W

For anyone interested, the solution was:

=COUNTIFS([Create Date]:[Create Date], AND(@cell >= (TODAY() - WEEKDAY(TODAY()) - 6), @cell <= (TODAY() - WEEKDAY(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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.