counting cells

[Tim Foster]

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

Tim

 

[Trevor]

COUNTA counts non-blank cells

 

[Peo Sjoblom]

If counting text only

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

--
Regards,

Peo Sjoblom

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

 

[CLR]

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