If I use COUNTA(range), it counts cells with the empty string (""). How do I avoid this? COUNTIFS(range,"<>"&"") doesn't seem to work.
Excel - Count all non-blank cells, excluding empty string
Viewed 3706
2 Answers
This ignores cells in range which contain empty strings (e.g. the result of IF(someCondition, someValue, ""). Tested with Excel 2013.
=COUNTIF(range, ">0")
Related