Tommy T Wrote:
Thanks Ron,

I'd managed to get that far but the trouble is that I need the cell to
be
counted if there is "abc" OR "def" within it. It's the OR bit which is
causing me trouble.

Any ideas?

Hi Tommy

Try this =SUM((COUNTIF(A:A,"*abc*")+(COUNTIF(A:A,"*def*"))) )


--
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