COUNTIF for a string with more than 255 characters?

[Nick70]

How can I count a specific text in a range using COUNTIF if the text has more than 255 characters?

For example formula

=countif(A1:A20,"Hello"

looks for text "Hello" in range A1:A20 but if instead of Hello I use a text with more than 255 characters then it no longer works and gives error: #VALUE.

Is there a way for Excel to still count text with more than 255 characters?

Thanks,
Nic

 

[Fluff]

Duplicate to: Type mismatch error when counting words/text with more than 255 characters

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.