COUNTIF with multiple criterias

Blue Pencil
Blue Pencil ✭✭
edited 03/29/22 in Formulas and Functions

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

Tags:

Best Answer

  • Jon Mark H
    Jon Mark H ✭✭✭✭✭
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!