Formula to count the blank cells in excel

When I was working on some data calculations in a excel sheet, we had a situation to count the blank number of cells in a range of rows. There are lot of statistical formulas available in excel

Here is the one formula which can be used to achieve this. and We can see how can use this.

We can use 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.

 

Remark

Cells with formulas that return "" (empty text) are also counted. Cells with zero values are not counted.

Example:

Hope this helps!