Countblank() Function in Microsoft Excel

CountBlank() Function In MS Excel:

As it is suggests it is used to count the numbers of empty cells only. The syntax CountBlank() function is as same as the count function:

=Countblank(cell_range)


Here is the example:

There is some of cells are blank and I am going the count that number of cells.












The answer is there are 03 cells are blank in the selected cell range as follow:







Janki Salvi

Be the best version of you! Be the core of you! Break down barriers, create your own opportunities for yourself. Nobody can know better than you for yourself.

Post a Comment

Previous Post Next Post