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

Kim Lincoln

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

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".

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! 👍️