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
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!