Using a COUNTIF function on large text fields

[Nick]

Hello all,

I am trying to use a countif function to count the number of
occurrences of a specific phrase within a column of data:

=COUNTIF(<column>,"*text*")

The problem I am encountering is that the countif function stops
searching after the first 254 characters in each field.

Any ideas how to get around this?

Thank you in advance.

 

[Dave Peterson]

=SUMPRODUCT(--(ISNUMBER(SEARCH("test",A1:A14))))

But you can't use the whole column.