Use SUMIFs and ISDATE to sum based on dates within the past week

Hello,

I'm attempting to use SUMIFs to sum one column based on whether another column has dates within the past 7 days. However, my current formula is unpareseable. All help is appreciated!

=SUMIFS([No if Sites]:[No of Sites], [Payments Closed Won Date]:[Payments Closed Won Date], ISDATE(TODAY()-7))

I have seen posted replies about using WEEKNUMBER and WEEKDAY, but I couldn't figure out how to apply those functions to this formula. Apologies if I've missed an answer to this specific question in another post.

Thank you,

Kim

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Your criteria is actually going to end up being

@cell>= TODAY(-7)

But the error itself is because it looks like you have a typo in that first range.

[No if Sites]:[No of Sites]

First column reference has "if" whereas second column reference has "of".

All comments

Paul Newcome

Your criteria is actually going to end up being

@cell>= TODAY(-7)

But the error itself is because it looks like you have a typo in that first range.

[No if Sites]:[No of Sites]

First column reference has "if" whereas second column reference has "of".

Kim Lincoln

Many thanks, Paul. Great catch on the typo and thank you for the criteria. I now have the following formula accurately report the sites.

=SUMIFS([No of Sites]:[No of Sites], [Payments Closed Won Date]:[Payments Closed Won Date], @cell >= TODAY(-7))

Paul Newcome

Great! Happy to help! 👍️

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.