Counting Items mentioned once in a multi drop down option

Austin Whisenant

How do I have on a tracking sheet where as long as the item is mentioned in a multi choice cell, it counts that item I am requesting? "At Risk Associate" needs to show 4 times, but doesn't show anything. I use COUNTIFS and tried HAS but nothing has worked.

Genevieve P.

Hi @Austin Whisenant

COUNTIF and HAS would be exactly what I would do in this situation. Are you receiving an error, or an incorrect count? It would be helpful to see the formula you tried and a screen capture of your sheet, but please block out any sensitive data.

Here's an example of the COUNTIF and HAS together, in a cross-sheet formula, using @cell:

=COUNTIF({Referenced Column}, HAS(@cell, "Criteria"))

The "Criteria" could either be built into the formula "like this", or it could be a referenced cell [Like this]@row.

You could add other criteria in a COUNTIFS as well, if you'd like:

=COUNTIFS({Referenced Column}, HAS(@cell, "Criteria"), {Other Column}, "Other Criteria")

Let me know if you still need help!

Cheers,

Genevieve