CountIFS Multiple Criteria including Checkbox "Checked"
Trying to count if column 1 contains a Checked Checkbox and another column on the same row contains a specific value?
Recieving an Unparsable error...
=COUNTIFS({Mandatory Delivery}, =1), {Current Project Phase}, CONTAINS("1 - Engage", @cell))
any ideas?
Best Answer
-
Hey @Jimthegem
The unparseable comes from closing the COUNTIFS function too soon. All of the criteria you listed is part of the same COUNTIFS query.
=COUNTIFS({Mandatory Delivery}, =1, {Current Project Phase}, CONTAINS("1 - Engage", @cell))
cheers,
Kelly
Answers
-
Hey @Jimthegem
The unparseable comes from closing the COUNTIFS function too soon. All of the criteria you listed is part of the same COUNTIFS query.
=COUNTIFS({Mandatory Delivery}, =1, {Current Project Phase}, CONTAINS("1 - Engage", @cell))
cheers,
Kelly
-
Thanks Kelly! You are a star.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 152 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!