COUNTIFS per month
I have the formula below, and need to count items per month
=COUNTIFS({CCS Scheduling sales person}, "RR", {CCS Scheduling Days over}, >1)
any ideas?
Thank you!
Answers
-
Hi @Lazar.A
If I'm understanding you correctly, you have a Date column in your source sheet and you want to filter down your current formula to a specific month.
If so, you can add in another {cross sheet reference} to that Date column, then check if the MONTH in each cell (@cell) of that column is equal to a specific number (ex. 1 for January).
MONTH(@cell) = 1
However, the MONTH function can sometimes error if there's a blank cell in the range, so we can wrap it in an IFERROR, like so:
IFERROR(MONTH(@cell), 0) = 1
Try something like this:
=COUNTIFS({CCS Scheduling sales person}, "RR", {CCS Scheduling Days over}, >1, {Date Column}, IFERROR(MONTH(@cell), 0) = 1)
Then you can swap out the = 1 to other months as needed.
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!