# Excel COUNTBLANK Function

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.

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

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.

## Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.