countif blanks

  • Thread starter Thread starter Radon
  • Start date Start date
R

Radon

I need to count the number of blanks in a range. I'm trying
countif(H1:H20,"<>""") but it's not working. Any ideas?
 
=COUNTIF(H1:H20,"<>"&"")

Or to account for the "dreaded SPACE BAR"
=SUMPRODUCT((LEN(TRIM(H1:H20))>0)*1)
 
This will count both empty cells and cells that contain formula blanks (""):

=COUNTBLANK(H1:H20)
 
Looking at your formula example, I'm assuming you want to *not* count
zero length strings ("") that might be returned by formulas already existing
in the referenced range.

This will *not* count < "" >, or < spaces > produced by the space bar:

=SUMPRODUCT(--(ISBLANK(H1:H20)))
 

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

Multiple Criteria 11
Excel Need Countifs Formula Help 0
Countif Problem 2
COUNTIF? 15
Countif and Right functions 8
Help with multiplication part of formula 2
Excel Numbering rows by font color, but skipping blanks 1
Excel How to use the Excel IF function 4

Back
Top