Count cells with text

[snoopy1461]

Is there a formular that can count how many cells have text in them?

i tryed to use

=SUMPRODUCT($A$1:$A$1000="")

But this didnt work, can anyone help me?

[jeffreybrown]

This should work...

=COUNTA(A1:A1000)

...to do it the way you proposed...

=SUMPRODUCT(--(A1:A1000<>""))

[Haseeb Avarakkan]

..count how many cells have text in them....

If you only want to count Text, try this.

=COUNTIF(A1:A100,"*")

(This will count a space too)

If you want to count non blank cells, COUNTA will work as Jeff suggested.