How to use Excel COUNTBLANK Function

    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”.


    COUNTBLANK (range)

    • 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.