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


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,



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!