CountIfs
Is there a limitation to Count if formulas?
COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA"))
I would like to add a 3rd Range and 3rd Criteria to this formula but seem to be having and issue doing that. Is there a limit?
Thank you
John
Answers
-
There are a few limits, but I believe your issue may be that you need to remove one of the closing parenthesis from the end of the formula.
-
Paul,
Here is the full formula I am trying to use
=(COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA"{Active Sites Range 50},"Not Started")
Its not working
-
Now you have an extra opening parenthesis at the beginning that needs removed, and you are missing the comma between the second criteria and third range.
-
Thanks Still no Luck after I made these changes
=COUNTIFS({Active Sites Range 2}, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), {Active Sites Range 52}, "Site Visit REA,"{Active Sites Range 50},"Not Started")
-
You have the comma after the second criteria inside of the quotes. Try putting the quotes before the comma.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!