Thanks Paul,

Trouble is that some of the cells contain both phrases, if I have two
different countif functions then they get double counted which I'm trying to
avoid.

Tom

"Paul Sheppard" wrote:


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