counting cells

  • Thread starter Thread starter Tim Foster
  • Start date Start date
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
 
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)
 
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
 
Back
Top