Countif Function

[Joseph M. Yonek]

I am trying to use countif to count cells that have text in a range.

Can someone help?

Thanks.
Joe

 

[mikelee]

not sure about countif, but you can use count and counta
to do it.

=counta(range) - count(range)

counta will count the nonblank cells, and count will
count the cells with numbers in them. the remainder
should be the cells with text.

hope that helps.

 

[Don Guillett]

try this
=SUMPRODUCT((ISTEXT(F1:F6))*1)