Is this what you mean? Assuming that A2:A10 contains the data...

=SUMPRODUCT(LEN(A2:A10)-LEN(SUBSTITUTE(A2:A10,6,"")))

Hope this helps!

http://www.xl-central.com

In article ,
Tom wrote:

I am trying to use countif to count the number of 6's in a list of numbers
from 1 to 100 for example. I only get one counted. I want it to count
16,26,36.46.56.60,61,62,63,64 etc. I tried putting a wildcard in the criteria
but it didn't work. I also tried count . Any suggestions would be appreciated

Thanks
Tom