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.