Countblank Function in Excel
Advertisements
Uses of Countblank Function in Excel
As the name implies, COUNTBLANK is a simple function that counts the number of blank or empty cells. The syntax is as follows:
Syntax
=COUNTBLANK(range)
The COUNTBLANK function works on a specified range as a parameter.
Looking at the example shown, COUNTBLANK helps count cells that are left blank/empty. We can use this function to find the entries that are left blank.
Google Advertisment