Countif status is "In Work" and Multiple choice contains

WldAcrUsa

Hello All,

I am trying to establish a Countifs formula that first checks status, then looks for a specific multiple choice option. Is this possible?

=COUNTIFS({AD-CVT Disc Status}, "In Work"), ({Above Findings}, (CONTAINS(Primary Column]@row, @cell))

Any help is appreciated! Thank you.

Leibel S

@WldAcrUsa

This should work, you do have a some extra parentheses:

=COUNTIFS({AD-CVT Disc Status}, "In Work", {Above Findings}, CONTAINS(Primary Column]@row, @cell))

WldAcrUsa

Here is the final formula I used.

=COUNTIFS({AD-CVT Disc Status}, "In Work", {AD-CVT Discrepancy Tracking Range 3}, HAS(@cell, [Primary Column]@row))

Paul Newcome

The original formula had an issue with the parenthesis as @Leibel Shuchat pointed out as well as a missing opening square bracket before Primary Column]@row.