Thread: 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 <6053908B-C0DD-4439-961A-A101BBCD8CE5@microsoft.com>,
"DanC" <DanC@discussions.microsoft.com> 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" <DanC@discussions.microsoft.com> wrote in message
news:6053908B-C0DD-4439-961A-A101BBCD8CE5@microsoft.com...
>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" <DanC@discussions.microsoft.com> wrote in message
news:6053908B-C0DD-4439-961A-A101BBCD8CE5@microsoft.com...
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" <DanC@discussions.microsoft.com> wrote in message
> news:6053908B-C0DD-4439-961A-A101BBCD8CE5@microsoft.com...
> 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
>
>