CountIFS Multiple Criteria including Checkbox "Checked"

Jimthegem

Trying to count if column 1 contains a Checked Checkbox and another column on the same row contains a specific value?

Recieving an Unparsable error...

=COUNTIFS({Mandatory Delivery}, =1), {Current Project Phase}, CONTAINS("1 - Engage", @cell))

any ideas?

Kelly Moore

Hey @Jimthegem

The unparseable comes from closing the COUNTIFS function too soon. All of the criteria you listed is part of the same COUNTIFS query.

=COUNTIFS({Mandatory Delivery}, =1, {Current Project Phase}, CONTAINS("1 - Engage", @cell))

cheers,

Kelly

Kelly Moore

Hey @Jimthegem

The unparseable comes from closing the COUNTIFS function too soon. All of the criteria you listed is part of the same COUNTIFS query.

=COUNTIFS({Mandatory Delivery}, =1, {Current Project Phase}, CONTAINS("1 - Engage", @cell))

cheers,

Kelly

Jimthegem

Thanks Kelly! You are a star.