count cells with text?

[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?

 

[Ray Carr]

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?

=COUNTA(A1:A20)

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

Ray

 

[Alan]

=COUNTA(A1:A15)-COUNT(A1:A15)
will count text only and ignore numbers,

 

[Harlan Grove]

=COUNTA(A1:A15)-COUNT(A1:A15)
will count text only and ignore numbers,

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

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

 

[Kevin Stecyk]

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

 

[Harlan Grove]

Why the double negative in front of "ISTEXT" in your solution? . . .

http://www.google.com/groups?selm=jemcgimpsey-C78655.06462206112003@msnews.microsoft.com

 

[Kevin Stecyk]

Harlan,

Thanks.

Regards,
Kevin

...
http://www.google.com/groups?selm=jemcgimpsey-C78655.06462206112003@msnews.microsoft.com

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.