How to count blank cells, including formulas that output a blank.
A blank cell is an empty cell and also a cell that contains a formula that outputs a blank. Note that a blank looking cell, one that contains only a space in it, will not be counted as blank.
=COUNTBLANK(A1:A6)
Result:
Note that cell A4 does have a formula in it; however, the formula outputs nothing, just a blank. As such, that cell is counted as a blank.
As you can see, 1 is not greater than 2 so "" is returned and output, which is a blank.
If you change the formula to result in TRUE or just put something between "" the blank count would be 1 because this cell would no longer be considered blank.
This is a simple function; just remember that it counts formulas that output nothing as blanks.
Download the spreadsheet for this tutorial to get this example in Excel.