COUNTIF formula

[John Sullivan]

I have a formula =COUNTIF(B7:B37,0) but I need it to only
count the number of rows in which any kind of text
appears. For example, if out of 31 rows, text appears in
10 of the rows, I would want the number "10" to appear as
the result. How do I do this?

 

[Don Guillett]

One, of several, ways
=COUNTA(B6:B18)-COUNT(B6:B18)

 

[Peo Sjoblom]

One way

=SUMPRODUCT(--(ISTEXT(B7:B37)))

 

[Harlan Grove]

One, of several, ways
=COUNTA(B6:B18)-COUNT(B6:B18)

...

Picky: your formula includes boolean and error values as well as text. The
strictly text count is given by

=SUMPRODUCT(--ISTEXT(B6:B18))

 

[Don Guillett]

Thanks. Harlan & Peo
Couldn't remember that one at the moment.