count specific item in a cell with multiple item.

Leod13

I'm trying to find a way how to count an specific item in a cell with multiple item. so far i tried this formulas but its not working.

=COUNTIF({Asset Health Tracker Range 1}, "unbalance", CONTAINS("Unbalance", {Asset Health Tracker Range 1}))

=COUNTIF(({Asset Health Tracker Range 1}, "unbalance")( CONTAINS("Unbalance", {Asset Health Tracker Range 1}))

Leod13

i figure it out

=COUNTIF({Asset Health Tracker Range 1}, CONTAINS("Mechanical Looseness", @cell))