counta

[Guest]

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

 

[JE McGimpsey]

one way:

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

 

[Tim C]

Try:

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

Tim C

 

[RagDyer]

Just another one:

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


Regards,

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


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

 

[Guest]

You win the prize. Your fomula worked.

thanks,

dan