Explanation
In this example, the goal is to count cells in arangethat are blank.
Counting blank cells in Excel can be tricky because cells canlookblank even when they are not actually empty.
The article below explains three different approaches.
COUNTBLANK function
The simplest way to count empty cells in a range is to use theCOUNTBLANK function.
COUNTBLANK is fully automatic, so there is nothing to configure.
The secondrange/criteriapair selects empty cells.
See also:50 examples of formula criteria.
SUMPRODUCT function
Another way to count blank cells is with the SUMPRODUCT function.
you could extend the logic used in SUMPRODUCT with other functions as needed.
The SUMPRODUCT function is more versatile thanRACON functionslike COUNTIFS, SUMIFS, etc.
and you will often see it used in formulas that solve tricky problems.
you’ve got the option to readmore about SUMPRODUCT here.
Cells that contain text, numbers, errors, spaces, etc.
Formulas that return empty strings ("")arecounted as blank.
COUNTA does not count empty cells.
