Thread: how to get the number of 6's in a list
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
  
Posts: 570
Default how to get the number of 6's in a list
Thanks a million!


"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
Reply With QuoteReply With Quote