Hi!
Try this:
=COUNTIF(A1:A100,"*whatever*")
Biff
"dcd123" wrote in
message ...
I am trying to use countif where the criteria in some cases will be one
word from a cell that has several words in it. I'm getting a total
count of 0 in these instances. Is there a way to set the criteria to
work this way or perhaps a different counting function?
Thanks!
--
dcd123
------------------------------------------------------------------------
dcd123's Profile:
http://www.excelforum.com/member.php...o&userid=25396
View this thread: http://www.excelforum.com/showthread...hreadid=397377