How can I count a specific text in a range using COUNTIF if the text has more than 255 characters?
For example formula
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
For example formula
Excel 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
