count not empty cell

[Maileen]

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

 

[Aladin Akyurek]

=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.

 

[Max]

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

 

[RagDyeR]

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!
==============================================



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