Thread: Colomn of strings, how to count each string with "abc" OR "def"
View Single Post
  #2   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default
On Mon, 5 Sep 2005 04:01:02 -0700, "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!


=COUNTIF(A:A,"*abc*")

or, if your string to search for is in a cell:

=COUNTIF(A:A,"*"&D2&"*")


--ron
Reply With QuoteReply With Quote