COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel

The following article introduces you to the COUNTBLANK function - one of the functions in the group of statistical functions that is very popular in Excel.

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 1

Description: The function performs counting empty cells in the list of arguments.

Syntax: COUNTBLANK (range)

Inside:

- range: Range to count empty cells.

Attention:

- The function performs counting empty cells, cells with a value of 0 are not counted.

For example:

Count the number of blanks in the table below:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 2

- In the cell to calculate, enter the formula : = COUNTBLANK (B6: D10)

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 3

- Press Enter -> number of blank cells in the data table is:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 4

- Where the cell value is 0 -> the function ignores not counting:

COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel Picture 5

Above are instructions and some specific examples when using the COUNTBLANK function in Excel.

Good luck!