Not really unless you really wanted to count all cells that are not empty

=COUNTIF(A:A,"~*")

will count cells that contain the asterisk and nothing else



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"harry cheema" wrote in message
...
Thanks for Help
But not
=COUNTIF(A:A,"~*")
BUT
=COUNTIF(A:A,"**")
WORKS.
THANKS PEO
HARRY

"Peo Sjoblom" wrote:

Precede with a tilde to make it work

=COUNTIF(A:A,"~*")

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon




"harry cheema" <harry wrote in message
...