Countifs with specific criteria for month & year
Kateshev
✭
Hi All,
Im a new smartsheet user and trying to complete a formula to count how many entries are in a specific month and year. I.e Entry relating to 'VIC" submitted in 'Oct' '2022' (pulling from another sheet)
I have been using the Countifs function:
=Countifs({SHEET Range 1}, "VIC", {SHEET Range 2}, "Month(10)", {SHEET Range 2}, "YEAR(2022)")
I believe i need to also use the IFERROR function as there will be fields with no dates yet.
I am getting a return of 0 everytime, but know there are entries there.
Any suggestions please? Thank you!
Answers
-
Try this:
=Countifs({SHEET Range 1}, "VIC", {SHEET Range 2}, AND(IFERROR(MONTH(@cell), 0) = 10, IFERROR(YEAR(@cell), 0) = 2022))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!