If each digits appears only once per cell then

=SUMPRODUCT(--(ISNUMBER(FIND(2,A1:A100))))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"James" wrote in message
...
I have tried COUNTIF and it did not work. Let me explain what I meant by
individual digits. The numbers in the cells B1:C38 are either 3, 4, or 5
digits, ie. 125, 8047, 19025. I need to know how many total times 0, 1, 2,
3,
etc. show up within all of the cells.
Sorry about not clarifying that in the begining.
Thank you.
--
James Bonds
Excel Learner


"JulieD" wrote:

Hi James

the COUNTIF function should give you this
=COUNTIF(B1:C38,0)
or if 0 is in cell E1
=COUNTIF($B$1:$C$38,E1)
and fill down for the other values

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"James" wrote in message
...
Sorry about the blank post.
I am trying to come up with a way to count individual digits i a list.
I have 2 list in column b & c that go from row 1 - 38. I need to know
how
to
count the total number of times each digit, 0,1,2,3,etc, appears in
the
list.
Is there a function that will do this?

Thank you,
--
James Bonds
Excel Learner