HELP! How do I modify my formula to separate months and years?
I am separating "Total Monthly Sales," but I need to separate the years as well. For example, our projects were sold in 2021, but carried over into 2022. I need to be able to separate 2022 and 2021.
Here is my formula:
=SUMIF([Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])
Answers
-
Here is my updated formula. I feel like I am close but obviously something is not working correctly.
=SUMIF([Date Awarded]:[Date Awarded], IFERROR(YEAR(@cell), 0) = 2022, [Date Awarded]:[Date Awarded], IFERROR(MONTH(@cell), 0) = 1, [Contract Amount]:[Contract Amount])
-
I've answered you on this other thread:
Let me know if you still have questions and I'd be happy to help further!
Cheers,
Genevieve
Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!