Home Application Office information

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)

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!

You've just finished reading the article "COUNTBLANK function - The function performs counting empty cells in the list of arguments in Excel" edited by the TipsMake team. You can save countblank-function-the-function-performs-counting-empty-cells-in-the-list-of-arguments-in-excel.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

« PREV : COUNTIF function -...
COUNTA function -... : NEXT »
Read more