I have a formula an iferror formula that puts in "" if an error occurs. This is a zero length string. I'd like to do a count if not equal to "".
=countif(A:A,<>"") 'is not a valid formulas
=countif(A:A,"<>") 'checks for actual blanks, not zero length strings
You could perhaps use SUMPRODUCT
since you have limited control over the range or criteria.
=SUMPRODUCT(--(LEN(A:A)<>0))
LEN(A:A)<>0
checks the length of the strings in the range A:A
for whether they are 0 or not. Wrapping it in parens and putting --
before it will convert True
to 1 and False
to 0
.
SUMPRODUCT
then takes all the 1s and 0s and add them up.
Rather than using COUNTBLANK
and subtracting from the total, you can use:
=COUNTIF(A:A,"?*")
?
is the single character wildcard.*
is the multiple character wildcard.
Combining these two, it will count if there are 1 or more characters.
Note that this works only if the cells contains strings, not numbers.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With