The countblank function is not an advanced one, but in order to understand and use the countblank function, users need to practice many different cases and understand the nature of this function.
Use the COUNTBLANK function, one of the Statistical functions, to count the number of empty cells in a range of cells.
Syntax: = COUNTBLANK(range)
The COUNTBLANK function syntax has the following arguments:
- Range (Required) The range from which you want to count the blank cells.
Example: Let’s look at some Excel COUNTBLANK function examples and explore how to use the COUNTBLANK function as a worksheet function in Microsoft Excel:
Use the COUNTBLANK function to find the number of students without a score in the data sheet.
Syntax: =COUNTBLANK(C2:C9)
Result:
