# Excel COUNTBLANK Function

Summary

The Excel COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, etc. are not counted. Formulas that return empty text are counted.

Purpose

Count cells that are blank

Return value

A number representing blank cells

Syntax

=COUNTBLANK (range)

Arguments

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

Usage notes

Use the COUNTBLANK function to count blank cells in a range, where the word *blank* means *empty*. For example, COUNTBLANK(A1:A10) will count the number of blank cells in the range A1:A10.

- Cells that contain text, numbers, errors, etc. are not counted.
- Formulas that return empty text ("") are considered blank and
*will*be counted. - Cells that contain zero are considered not blank and will
*not*be counted.