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?
Bookmarks