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.
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:
- In the cell to calculate, enter the formula : = COUNTBLANK (B6: D10)
- Press Enter -> number of blank cells in the data table is:
- Where the cell value is 0 -> the function ignores not counting:
Above are instructions and some specific examples when using the COUNTBLANK function in Excel.
Good luck!