How to use COUNTBLANK Function in Excel

how to use excel countblank function

Quick Intro

Use 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 the 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 more about this tips

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 it, I would love to hear from you.

You can also use COUNT | COUNTA which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.