counting data

T

TrentA

If I have 20 cells in a column with text data, how do I construct a
formula to count only the cells in that column that contain data.

Ted
Bob
Ron
Larry

In cell a1 I need the answer 4

Thanks
 
G

Gord Dibben

=COUNTA(range) will count every cell with something in it.


Gord Dibben MS Excel MVP
 
T

TrentA

=COUNTA(range) will count every cell with something in it.
Click to expand...

Simple enough; thanks. By the way, I checked the help file and I
didn't see that solution. Maybe I overlooked it.

I appreciate the quick response.
 
G

Gord Dibben

Thanks for the feedback.

It is in help under "count" Click on "count non-blank cells"


Gord
 
Top