COUNTIF Function for String of more than 255 Characters

[akbarmajor]

I want to count number of times a string is appearing in a range of cells, for which I entered COUNTIF formula in an adjacent column i.e. Column C.

=COUNTIF($A$2:$A$929,B2)

The formula gives me perfect results untill the string length goes more than 255 characters.

So I wanted to know is there any way I can count number of times a string of more than 255 characters is appearing in a range of cells?

[daddylonglegs]

You can use SUMPRODUCT like this

=SUMPRODUCT(($A$2:$A$929=B2)+0)

[akbarmajor]

Great it worked, Thanks a lot for prompt response...