You win the prize. Your fomula worked.

thanks,

dan

"RagDyer" wrote:

Just another one:

=COUNTIF(A:A,"*?")
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------


"DanC" wrote in message
...
I want to count the cells that have text but are not "". I understant that
counta() will count all non empty cells but "" is not the same as empty. I
have tried =counta(field,"<""" and variations but cannot get the proper
result.

dan