Counting cells that contain data

[Karl]

Hi,

I'm trying to use the count function to count the number of cells in a range
of cells which contain data. I can't figure out how to do it, can anyone help.

Thanks

Karl

 

[Gord Dibben]

=COUNTA(range)

COUNT only counts numerics.


Gord Dibben MS Excel MVP

 

[Teethless mama]

=COUNT(A1:A100)