count specific item in a cell with multiple item.

Leod13 · 09/17/24

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 · 09/17/24

i figure it out

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

Leod13 · 09/17/24

i figure it out

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

Best Answer