# Excel COUNTBLANK Function

The Excel 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 empty text are counted.

*range*- The range in which to count blank cells.

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 empty text are counted. COUNTBLANK takes just one argument, range, which must be a cell range.

### Examples

In the example shown, the formula in cell E6 is:

=COUNTBLANK(B5:B15) // returns 3

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:

="" // formula in B13

COUNTBLANK considers B13 blank and includes it in the count.

### Invisible characters

Some cells look empty, but actually contain invisible characters. To check which cells are blank use Go To > Special > Blanks:

- Select a range
- Open Go To dialog (Control + G)
- Press "Special"
- Select "Blanks"

### Functions for counting

- To count numbers only, use the COUNT function.
- To count numbers and text, use the COUNTA function.
- To count with one condition, use the COUNTIF function
- To count with multiple conditions, use the COUNTIFS function.
- To count empty cells, use the COUNTBLANK function.

### Notes

- Cells that contain text, numbers, errors, etc.
*are not*counted. - Cells with formulas that return an empty string ("")
*are*counted. - Cells that contain zero
*are not*counted.

## Download 100+ Important Excel Functions

Get over 100 Excel Functions you should know in one handy PDF.