Awesome! Thanks

"DaveB" wrote:

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?