how to get the number of 6's in a list
Hi
What if you have 66 in your range? Do you want to count it as 1 or 2?
If 2, the above solutions works well.
otherwise, try this array formula, confirm by Ctrl,Shift and Enter
=SUM(IF(LEN(E19:E31)-LEN(SUBSTITUTE(E19:E31,6,"")),1))
this will count 66 as 1 occurrence rather than 2
--
Hope this is helpful
Pls click the Yes button below if this post provide answer you have asked
Thank You
cheers, francis
Am not a greek but an ordinary user trying to assist another
"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
|