The COUNT(...) function only counts numeric values. To count all values use
COUNTA(...), so your formula would be:
=COUNTA(H1:H5)
--
Regards,
Dave
"dnm" wrote:
One more question. Every time I try to use the count function it keeps
displaying 0 even though I have values. For example:
H
1 REC 21
2 REC 24
3 REC 19
4 REC 22
5 REC 21
Which I would then use the formula =COUNT(H1:H5) which should display 5, but
it shows 0.
Does anyone know why this could be happening?
|