counting data

  • Thread starter Thread starter TrentA
  • Start date Start date
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
 
=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.
 
Thanks for the feedback.

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


Gord
 
Back
Top