Author: Oscar Cronquist Article last updated on March 29, 2018

The COUNTBLANK function counts empty or blank cells in a range.

The picture above demonstrates the COUNTBLANK function entered in cell F3. The evaluated range is C3:C10, two of the cells contains formulas, three cells seem to be empty but only one is in fact empty.

Cell C4 has a formula that returns a blank, note that the COUNTBLANK function considers this cell empty. Cell C7 has a space character and is therefore counted. Only cell C6 is really empty.

Use the TRIM function to remove space characters.

Excel Function Syntax

COUNTBLANK(value1, [value2], ...)

Arguments

value1 Required. A cell reference to a range for which you want to count empty cells.
[value2] Optional. Up to 254 additional arguments like the one above.

Comments

The COUNTBLANK function counts errors as not empty.