CountIf limitation

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