COUNTIF and CONTAINS in a formula.
Hello! I am trying to count the number of times where a specific phrase is.
For example, I have XX - YYYYY as my specific phrase; but some times there might be an XX - YYYYY - ZZZZ or even UUU - XX - YYYYY - ZZZZ.
Is there anyway to count the amount of times that "XX - YYYYY" exists?
Help Article Resources
Check out the Formula Handbook template!