COUNTIF

[Don]

I need to count the number of cells containing a
particular character string. There may be other
characters in the string. Just want to count it if my
string is in it. Any ideas??

Thank you

 

[Frank Kabel]

Hi
one way:
=SUMPRODUCT(--(ISNUMBER(FIND("search_string",A1:A1000))))

 

[Dave R.]

yes,
COUNTIF(A1:A100,"*mystring*")

 

[Harlan Grove]

I need to count the number of cells containing a
particular character string. There may be other
characters in the string. Just want to count it if my
string is in it. Any ideas??

=COUNTIF(YourRangeHere,"*YourSubstringHere*")