Try these:
To count *only* alpha text:
=COUNTIF(A:A,"?")
To count alpha *and* numeric text:
=COUNTIF(A:A,"*?")
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Maileen" wrote in message
...
Hi,
I have a sheet on which some data are written.
I would like to count how many rows have data. (data = text, not numbers)
something like :
=COUNTIF(range A:A;<"") and it should give me the amount of row where data
are written.
thx,
Maileen
|