Count Number Of Blank Cell In Excel

 

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.

Capture

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.




Capture

As you could see the number of blank cell is calculated.

Capture

Hope this helped.

Share The Knowledge

Random Posts

Leave a Reply