In this lesson we will learn how the COUNTBLANK function works in Excel. The COUNTBLANK function is used to count the number of blank cells within a supplied range of cells or values.
- Here the argument range can be values, arrays of values, or references to cell ranges within which you want to count the number of cells that are empty.
Let’s understand with a simple example. In below table we have 2 different set of values in column A & B.
Now in cell E1 we have added the below formula.
This will calculate the number of blank cells in the cell range A2:A6 and returned the count 2 in cell E1.
In the same way we have used the COUNTBLANK formula in cell E2 & E3 to count the no. of blank cells in cell range B2:B6 and A2:B6 respectively.