View Single Post
  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


Tommy T 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!


Hi Tommy

Try this =COUNTIF(A1:A2,"*abc*") change the range A1:A2 to suit your
data, change abc to def to count the other option


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401899