And, as is normal around here, we'll never know without the OP's response
.... but ... it does enliven the thread *and* enlighten the archives.<bg
--

Regards,

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

"Bob Phillips" wrote in message
...
I agree, but isn't it always. I picked up specifically on the ANY.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"RagDyer" wrote in message
...
Interpretation is questionable here concerning the exact meaning of
"text".

COUNTA() counts *non-empty* cells ... including numbers, errors (#DIV/0!),
logical values (TRUE, FALSE) and zero length strings ( "" ).

To count *only* text ... including alpha and numeric *text*, try this:

=COUNTIF(A1:A20,"*?")

--
Regards,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"Bob Phillips" wrote in message
...
=COUNTA(A1:A20)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Forgetfulpgk" wrote in message
...
What is the formula for counting the number of cells containing ANY
text?