COUNTIF with multiple criterias

Blue Pencil

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

Jon Mark H

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

Jon Mark H

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

Blue Pencil

https://community.smartsheet.com/discussion/comment/324404#Comment_324404

Worked Perfectly, thanks!

Jon Mark H

@Blue Pencil

You're very welcome! Glad I could help!