COUNTBLANK

The COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, spaces, etc. are not counted. Formulas that return an empty string ("") are counted as blank. COUNTBLANK takes just one argument, range, which must be a cell range. In the example shown, the formula in cell E6 is: COUNTBLANK returns 3 since there are 3 blank cells in the range. Note that cell B12 is not included because it contains a space character (" "). Cell B13 contains a formula that returns an empty string: COUNTBLANK considers B13 blank and includes it in the count. The IF function is often used to return empty strings. For example, if A1 contains 21, this formula in B1 will return an empty string: