COUNTIF with multiple criterias
I have a formula in my sheet to count the number of unchecked boxes in a column. I'd like to set a condition so that it only counts if the box is unchecked and there is a name in the "facilitator" column (Contact email format). Alternatively, if it's easier, it could count IF there is a date in the automatically generated "date" column.
Here's my current formula which returns "# Incorrect argument set"
=COUNTIF([Were all attendees in the meeting room on time?]:[Were all attendees in the meeting room on time?], 0, Facilitator:Facilitator, <>"")
note: The 0 in the formula = box is unchecked
Best Answer
-
Hey Blue -
You're close!
COUNTIF only takes (1) range & (1) criterion -
Looks like you need a COUNTIFS instead:
=COUNTIFS([Were all attendees in the meeting room on time?]:[Were all attendees in the meeting room on time?], 0, Facilitator:Facilitator, <>"")
Let me know if that works or not for you!
-Jon Mark
Answers
-
Hey Blue -
You're close!
COUNTIF only takes (1) range & (1) criterion -
Looks like you need a COUNTIFS instead:
=COUNTIFS([Were all attendees in the meeting room on time?]:[Were all attendees in the meeting room on time?], 0, Facilitator:Facilitator, <>"")
Let me know if that works or not for you!
-Jon Mark
-
Worked Perfectly, thanks!
-
You're very welcome! Glad I could help!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!