=COUNTA(A:A)

would count everything, including numeric data.

=SUMPRODUCT(--ISTEXT(A2:A100))

would count just text data, but testing whole columns are not allowed.

"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