how to use excel countblank functionUse Excel COUNBLANK Function to count cells which are blank.

In simple words, when you specify a range of cells it will return the number of cells which have no value in it.

And, if there is no blank cell in the range it will return “0”.



range A range of cells from which you want to count blank cells.

More Information on Excel COUNTBLANK Function

  • If there is a zero in a cell, that will consider as a non-blank cell, hence ignored.
  • And, if a cell has a formula resulting in an empty (=” “), that will also consider as a non-blank cell.
  • Cells contain numbers, text, errors & symbols are ignored.


In below example, I have used COUNTBLANK function to count blank cells from the range A2:A8.


In this range, I have total 3 cells which are blank but cell A7 has a formula in it which results in a blank cell.

The function has returned 2 as cell A4 & A5 are the only cells which are blank and have no values.

Sample File

download sample file to learn about excel countblank function

What’s Next?

To learn more about excel MID function you can check Microsoft’s Help Section.

And, if you have a unique idea to use countblank function, I would love to hear from you.

You can also use COUNT | COUNTA which are highly useful like countblank.

Apart from this, I have a list of excel functions and some real life formulas examples.