count cells with text?

  • Thread starter Thread starter rusty
  • Start date Start date
R

rusty

How do I write a formula to check a range and count how
many cells have text in it? ie. count a column to add up
how many people are in the list?
 
rusty said:
How do I write a formula to check a range and count how
many cells have text in it? ie. count a column to add up
how many people are in the list?
Click to expand...

=COUNTA(A1:A20)

This will return how many cells are occupied by text or numbers, A1 thru A20
being the range...

Ray
 
=COUNTA(A1:A15)-COUNT(A1:A15)
will count text only and ignore numbers,
Click to expand...

That includes cells containing boolean and error values as well as text. For
text and only text, one alternative is

=SUMPRODUCT(--ISTEXT(A1:A5))
 
Harlan,

My question is slightly off-topic, but it might nonetheless assist Rusty
too.

Why the double negative in front of "ISTEXT" in your solution? I trust that
it is correct, and I have seen others use it as well in their formulas.
However, I am curious as to why the double negative.

TIA.

Regards,
Kevin
 
Back
Top