Excel’s COUNTBLANK() function

Excel’s COUNTBLANK function counts the number of cells in a given range that are blank. The cells must be completely blank — don’t let yourself be caught out by a cell that has a space in it — a space is a character as well! Download the data file and follow along:

1. Syntax
2. Example
3. See also

1. Syntax

=COUNTBLANK(range)

The COUNTBLANK function takes one argument: the range specifies the cells being evaluated.

Returns an integer representing the number of blank cells in the range.

2. Example

1. The COUNTBLANK function in cell D19
2. The range being evaluated

Be sure to test what happens if there is a space in a cell: select cell D14, hit Space on the keyboard and watch what happens to the result in cell D19.

3. See also

• COUNT function
• COUNTA function
• COUNTIF function