COUNTIF formula

J

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?
 
H

Harlan Grove

One, of several, ways
=COUNTA(B6:B18)-COUNT(B6:B18)
Click to expand...
...

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the proper style field and the numbered paragraph value within the style 0
Finding the weighted average of text that have been given values 1
Finding the right style field in VBA 0
Excel does not accept text format! 0
How can the font and size of (all) citation numbers be altered? 1
Excel Countif Function - Calculating Between Two Sets of Values 3
simple countif formula 2
Using <= in countifs statement 1

Top