SUMIF that excludes dates in the past

Hi, is there a way to reformat this formula below to say that you only want to take data from a particular month and year and sum it up but not include any dates from the past- so dates that are not in the future?
This formula below is referencing another sheet of mine that says it wants to sum up all of the pieces of art for a particular month and year but I want to reformat it to exclude dates from the past.
SUMIFS({High Level Artwork Status: POA Count}, {High Level Artwork Status: FK DATE}, IFERROR(MONTH(@cell), 0) = [Primary Column]@row, {High Level Artwork Status: FK DATE}, IFERROR(YEAR(@cell), 0) = 2022)
Best Answer
-
Hey @Mina S
If I understand you correctly, you want to modify your existing formula that is specific to a month and a year to sum anything that is not in the past.
=SUMIFS({High Level Artwork Status: POA Count}, {High Level Artwork Status: FK DATE},IFERROR(@cell,0)>=TODAY())
Does this work for you?
Kelly
Answers
-
Hey @Mina S
If I understand you correctly, you want to modify your existing formula that is specific to a month and a year to sum anything that is not in the past.
=SUMIFS({High Level Artwork Status: POA Count}, {High Level Artwork Status: FK DATE},IFERROR(@cell,0)>=TODAY())
Does this work for you?
Kelly
-
Thank you @Kelly Moore. That helped immensely!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!