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
Help Article Resources
Check out the Formula Handbook template!