Try...

=SUMPRODUCT(--(ISNUMBER(SEARCH("abc",A1:A100))+ISNUMBER(SEARCH(" def",A1:A
100))0))

or

=SUMPRODUCT(--(ISNUMBER(SEARCH(B1,A1:A100))+ISNUMBER(SEARCH(C1,A 1:A100))
0))

....where B1 contains your first criterion, such as abc, and C1 contains
your second criterion, such as def.

Hope this helps!

In article ,
"Tommy T" <Tommy wrote:

I have a colomn of alpha-numeric strings and need to count cells which
contain phrase A or phrase B buried within them. This is driving me crazy,
please help!