How do I use COUNTIF to count cells w/text?

[VH5150]

Thanks,
Jim

 

[Juan Pablo González]

Can you post an example of what you're after ?

 

[Zack Barresse]

=SUMPRODUCT(--(ISTEXT(H2:H11)))

change range to suit.

HTH

edit: btw, this formula will count a cell as 1, and a cell w/ alpha-numerics as text (1) also.

 

[VH5150]

God you guys are good! I can't believe how quickly you get back to me after I post. Thanks again,

Jim

 

[zhdi]

=COUNTIF(H2:H10,"*")
the formula above is ok.