COUNTING TEXT CELLS IN A COLUMN
 

How do we count cells containing text, excluding blank cells?

=COUNTA(D:D)-COUNT(D:D)

--
HTH

Bob Phillips

"Maureen" wrote in message
...
How do we count cells containing text, excluding blank cells?

Try this:

=COUNTIF(A:A,"*?")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Maureen" wrote in message
...
How do we count cells containing text, excluding blank cells?

RagDyeR wrote...
Try this:

=COUNTIF(A:A,"*?")
....

Given the internals of pattern processing, it'd be more efficient to
use =COUNTIF(A:A,"?*").

Bob Phillips wrote...
=COUNTA(D:D)-COUNT(D:D)
....

Picky: that'd include cells evaluating to errors and booleans in the
count. It'd also include cells evaluating to "".