Excel formla

B

Bob Phillips

=COUNTA(A1:A20)

--
HTH

Bob Phillips

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

RagDyer

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,"*?")
 
B

Bob Phillips

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)
 
R

RagDyeR

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 !
----------------------------------------------------------------------------
-------------------

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)
 
B

Bob Phillips

I agree, that is why there is no reason to assume a 'correct' response is
the final response (even if the OP says it is <G>).

--
HTH

Bob Phillips

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