Countif single name when multiple names in a cell

davelenard

COUNTIF([Brand]:[Brand], HAS(@cell, "Acme")) is my formula, but some cells may have multiple names in the cell. The formula currently is only counting those that are only "Acme"

Jason Tarpinian

That should count all cells, even if there are other values:

Do you have a screen shot to share? Note that HAS() is different than CONTAINS() and will only count if the exact string matches. So HAS() will not count "Acme2" if you are searching for "Acme"

davelenard

Brand
Acme
Acme; Boris
Natasha; Acme

This results in count of 1 for "Acme"