counting cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tim Foster - 22 Jun 2004 21:02 GMT

Hi,
Can someone tell me what function works to count the number of cells
in a given row that contain text?
Many thanks.

Tim

Reply to this Message

Trevor - 22 Jun 2004 21:35 GMT

COUNTA counts non-blank cells

> Hi,
> Can someone tell me what function works to count the number of cells
> in a given row that contain text?
> Many thanks.
>
> Tim

Reply to this Message

Peo Sjoblom - 22 Jun 2004 23:21 GMT

If counting text only

=SUMPRODUCT(--(ISTEXT(A2:A30)))

Signature

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)

> COUNTA counts non-blank cells
>
[quoted text clipped - 4 lines]
> >
> > Tim

Reply to this Message

CLR - 22 Jun 2004 23:47 GMT

Hi Tim..........

=COUNTA(YourRange)-COUNT(YourRange) may do what you want...........

COUNTA counts every cell with numbers, text, numbers pre-formatted as text,
and numbers entered as text with a leading apostrophe.

COUNT will only count cells with numbers..........

The combination of their use will count all the cells with values therein,
and subtract the ones with numbers........leaving only the "text" or
non-number values............

Vaya con Dios,
Chuck, CABGx3

> Hi,
> Can someone tell me what function works to count the number of cells
> in a given row that contain text?
> Many thanks.
>
> Tim

Reply to this Message