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