Try

=COUNTIF(A1:A10,"*George*")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ltat42a"
wrote in message
...

I'm using the countif formula to look up certain keywords in a
column(=COUNTIF(Sheet1!G1:G1170,"George"). In my column, there
will be
different entries other than just "George". There may be George
Smith,
George Jones, George Thompson, etc...etc...
Is there a better formula that will return a result for all
"george's".
Right now, it doesn't return anything because of the various
George's.

Thanx.


--
Ltat42a
------------------------------------------------------------------------
Ltat42a's Profile:
http://www.excelforum.com/member.php...o&userid=24735
View this thread:
http://www.excelforum.com/showthread...hreadid=494440