counting cells

T

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
 
P

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)
 
C

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
 
Top