They are probably text, try
=COUNTA(cell range)
--
Regards,
Peo Sjoblom
(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
"EmilyJ" wrote in message
...
Working with a very large Excel database and must count each unit. Have
tried using =COUNT(cell range) but it does not work. I have 0 as an
answer.
What am I doing wrong? All units are in one cell but they are different
(some up to 1000). I use Excel 2002.
|