See if this works for you:

A1: COUNTIF(C10:C1000,"*yellow pages*")

That will count any cell that includes "yellow pages"

Examples that qualify:
From yellow pages
newspaper and yellow pages
yellow pages
etc

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=516297