countif blanks

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

Don Guillett

=COUNTIF(H1:H20,"<>"&"")

Or to account for the "dreaded SPACE BAR"
=SUMPRODUCT((LEN(TRIM(H1:H20))>0)*1)
 
T

T. Valko

This will count both empty cells and cells that contain formula blanks (""):

=COUNTBLANK(H1:H20)
 
R

Ragdyer

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)))
 
R

rich jackson

This is GOLD

=SUMPRODUCT(--(ISBLANK(K4:K24)))

This used to do the same thing but not anymore

COUNTIF(C13:L18,">"" ")
 

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

Creating Different Headers in Word 0
Sumproducting counting blanks 4
Pull a column header from a row of numbers 1
Using <= in countifs statement 1
PRINTING handiest filled statistics 0
How to count the number of times a number is repeated in a column 2
Counting Cells With Multiple Criteria on Multiple Sheets 0
Counting Cells With Multiple Criteria on Multiple Sheets 0

Top