I am attempting to count how many times a specific word appears in a text entry in a column. I normally achieve this by filtering by "contains" on the actual data sheet. My goal here is to automate this with a formula.
Example: Count how many times the Resolution column contains "duplicate"
I have tried the COUNTIF formula with CONTAINS and always get a 0. I've also tried HAS and FIND and get errors.
Any help is appreciated.
Help Article Resources
Check out the Formula Handbook template!