This post demonstrates how to count the blank cells in a column in excel, we may have a long list coming from a source and we are interested to count the blanks cells to see how many values are not there.
Let’s see how we can count the number of blank cells in a column in excel.
Use the Formula Coutnblank (Range) to achieve this. It takes the range in which we want to calculate the counts of blank cells as its argument.
As you could see the number of blank cell is calculated.
Hope this helped.