Counting a Specific Word in a Multi-Select Column

Hammermill21

Hello!

I am trying to count a center word in a column that has multi-select and it is just not working. This is what I have now:

=COUNTIFS({Lakeside Village Opening - Action Items Range 1}, [Primary Column]@row, {Coronavirus Unified Working Group - Action Range 1}, $[Column4]$7)

The [Primary Column]@row is the word that is in a multi-select column.

Thank you!!

Paul Newcome

Try using a CONTAINS function...

=COUNTIFS({Lakeside Village Opening - Action Items Range 1}, CONTAINS([Primary Column]@row, @cell), {Coronavirus Unified Working Group - Action Range 1}, $[Column4]$7)