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" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
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 "".