Your original formula will work even tho there are no numerical values,
however, this will do it by itself.
(Substitute your column designation for A:A)

=COUNTA(A:A)

Vaya con Dios,
Chuck, CABGx3


"peace" wrote in
message ...

Hi , I have a column with text and blanks and I am trying to count the
total number of cells with text. I searched through this site and
found something with COUNTA() - COUNT() but this doesn't work because I
have no numerical values. Any ideas are sincerely appreciated


Thank you


--
peace
------------------------------------------------------------------------
peace's Profile:
http://www.excelforum.com/member.php...o&userid=27035
View this thread: http://www.excelforum.com/showthread...hreadid=444459