COUNTIF help needed!

[Mark]

How do I count all of the text cells in a given range that
are NOT null (i.e. all that contain text).

I tried
=COUNTIF(D1420,<>"")
but that gave me an error message.

What's the answer??

 

[rank Kabel]

Hi
one way:
=COUNTA(D1420)

or

 

[Dave R.]

Frank- What's up with your name? You're missing letters from it on some of
your posts.

 

[Frank Kabel]

Hi Dave
just forced to use this wonderful CDO interface from
Microsoft (as my client does not allow direct access to
newsservers) during the day