Sounds like your numbers are being stored as text. If this returns a value

=SUMPRODUCT(--(C4:C340))

that will confirm it.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"LInda" wrote in message
...
Yes, I've tried that and other variations from the discussion group
answers
that seemed logical... well for the questions posed they were...

Anyway...That one you show returns a value of "0". In that column of 31
cells, two contain numbers, 3 contain zeros, and the rest are blank. I
can
count the zero's, I can count the blanks, but counting the numbered cells
is
.... well .... I'm drawing a blank.

"goto_guy" wrote:


Have you tried
=COUNTIF(C4:C34,"0")


--
goto_guy
------------------------------------------------------------------------
goto_guy's Profile:
http://www.excelforum.com/member.php...o&userid=30557
View this thread:
http://www.excelforum.com/showthread...hreadid=528316