The AI-generated formula shows an invalid data type. I'm not sure what is wrong. What I want to do is count the number of items that are good for the month of December. =COUNTIFS([Fault Severity]:[Fau…
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("U…
I am looking for the right formula so that changing the Month does not affect the count of the previous month. =COUNTIFS({Asset Health Tracker Range 2}, "Lawn", {Asset Health Tracker Range 3}, "August…