Creating formula with multiple items selected

Kim L

I have a sheet that has a field that allows multiple items to be in the field. I want to create a formula that will allow me to count the row if even one of the items in the row matches my criteria but it's only counting the row if there aren't multiple items in the field.

Corey W.

This should work:

=COUNTIF([Multi Field]:[Multi Field], CONTAINS("Cherry", @cell))

Corey W.

This should work:

=COUNTIF([Multi Field]:[Multi Field], CONTAINS("Cherry", @cell))

Kim L

Thank you!