COUNTBLANK Function in Excel: Syntax and Examples

This article provides a clear overview of COUNTBLANK Function in Excel, with the main facts, useful context, and practical details organized for easy reading.

Description

The COUNTBLANK () function helps to count the number of blank (empty) cells in a selected range or array in Excel.

Syntax

= COUNTBLANK (range)

Arguments

- range: is the only and mandatory parameter of the function, range is the sequence of cells, an area to count the number of empty (empty) cells.

Note

- Cells containing formulas that return empty (empty) text will count like normal blank cells.

- Cells with value = 0 will not be counted.

For Example

Count students without points (number of empty cells) in the following example:

In the data table with cell E3, the function returns an empty value.

Apply the formula COUNTBLANK (): = COUNTBLANK (E6: E13)

And the result is 3 because cell E3 is the formula but the result is empty.

This article described the syntax and usage of the COUNTBLANK () function. Hopefully, with the above simple example, you will understand how to use the COUNTBLANK () function in Excel. Good luck!