View Single Post
  #4   Report Post  
RagDyeR
 
Posts: n/a
Default

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