counta
 

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

one way:

=SUMPRODUCT(--(LEN(A1:A1000)0))

In article ,
"DanC" wrote:

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.

Try:

=COUNTIF(A1:A20,"""")

Tim C

"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

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

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