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

COUNTBLANK function: The function performs counting empty cells in the list of arguments. Syntax: COUNTBLANK (range)

COUNTA function - The function performs counting non-blank cells in the list of arguments in Excel
COUNT function - Function that counts cells containing numbers 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.

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

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:

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

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

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

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

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

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

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

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

Good luck!

« PREV POST