Buzz
In the previous article, we introduced you to the COUNT() function – a function that counts cells containing numbers in a list of arguments. In this article, we'll introduce another counting function – the COUNTBLANK() function. This function will help you count empty cells within the selected cell range.
Description
The COUNTBLANK() function helps count the number of empty cells within a selected range or array in Excel.
Syntax
=COUNTBLANK(range)
Where:
- range: is the sole and mandatory parameter of the function, representing a series of cells or a range to count empty cells.
Remarks
- Cells containing formulas that return empty text will be counted as empty cells by the function.
- Cells with a value of = 0 will not be counted.
Example
Count the number of students without grades (empty cells) in the following example:
In the data table, cell E3 contains a formula returning an empty value.
Applying the formula COUNTBLANK(): =COUNTBLANK(E6:E13)
And the result is 3 because cell E3 contains a formula but returns an empty value.
The article has described the syntax and usage of the COUNTBLANK() function. Hopefully, with the simple example above, you will understand how to use the COUNTBLANK() function in Excel. Wish you all success!
