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,"<>""") but it's not working. Any ideas?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Don Guillett
=COUNTIF(H1:H20,"<>"&"")
Or to account for the "dreaded SPACE BAR"
=SUMPRODUCT((LEN(TRIM(H1:H20))>0)*1)
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)
=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)))
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)))