CountIF function cannot search for text longer than 255 chars.
This is mainly found here …
https://support.office.com/en-us/article/COUNTIF-function-E0DE10C6-F885-4E71-ABB4-1F464816DF34
CountIf limitation
Excel f(x)s = Excel Functions
