=countif(range,"*jack")

range means the range of cells containsing the dta like 7pmM jack
for e.g. if your data is in A1 to A10 the formula is

=countif(a1:a10,"*jack")

note the star symbol. that is wild card any entry with Jack.

=============
--
remove $$$ from email addresss to send email

========
"bschute" wrote in
message ...

I have several columns with 7pmM Jack or simialr enteries. How do I get
a sum of all Jack names in each column-- probably need an If statement
-which one,
What characters preceed and follow the name e.g."*etc.


--
bschute
------------------------------------------------------------------------
bschute's Profile:
http://www.excelforum.com/member.php...o&userid=27349
View this thread: http://www.excelforum.com/showthread...hreadid=468579