count not empty cell
 

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

=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

If the source range A2:A100 may also contain "text numbers" besides "real"
alpha text, and these "text numbers" are to be excluded from the count, then
maybe try:

=SUMPRODUCT(--ISERROR(A2:A100+0))

Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Maileen" wrote:

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

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