Count the number of blank cells in a range in Microsoft Excel

In this chapter, you’ll learn about how to count the number of cells which is blank within a range in Microsoft Excel. We will make use of COUNTBLANK function.

COUNTBLANK function is used to count the blank cells within a defined range.

 
image 1

 

Let’s take an example and understand:-

We have data in which, few cells are blank and we want to count blank cells.

image 2

 

To count the blank cells follow below given steps:-

  • Enter the formula in cell D2
  • =COUNTBLANK(A2:C10)

image 3

 

  • Press Enter
  • Function will return 10, it means 10 cells are blank within the range

image 4
 
In this way we can count blank cells within range by using COUNTBLANK function in Microsoft Excel.

Few more examples:-

How to Count Blank and Non Blank Cells in Microsoft Excel?

Checking Whether Cells in a Range are Blank, and Counting the Blank Cells?

 

image 48

 

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

 
 

Users are saying about us...

  1. "Hi
    I have one query regarding my excel sheet. My sheet contains data like
    A B C
    1 X Y Z
    2
    3 Y Z X
    4 K P Q
    5
    6
    7

    Now from here i wanted to know that which are those rows and there count that contains data in all it's cells

    It's very urgent
    Thankx "

  2. "In the above example, presumably the answer you want is '3'?

    Please can you clarify:

    What answer would you want, if a row contained data in, say, Column B only (not Column C) for example?

    My general suggestion is to add a formula in Column D that creates a flag (0 or 1) indicating whether your criteria have been met. You can them sum that column.

    Hope that helps, "

  3. "I have a spreadsheet that I would like to equip with a checkbox on each of 134 rows in 7 columns. I was able to get them working once but now they seem to lock up the spreadsheet and render it useless. (good thing I saved the original!) Anyway, I am an excel rookie so if you could give me any tips I'd really appreciate it!

    Thank you,

    Steve

    (by the way, awesome site, excel-ent advice. Sorry bout that one, really)"

  4. "Hi
    I have one query regarding my excel sheet. My sheet contains data like
    A B C
    1 X Y Z
    2
    3 Y Z X
    4 K P Q
    5
    6
    7

    Now from here i wanted to know that which are those rows and there count that contains data in all it's cells

    It's very urgent
    Thankx
    Raghwendra"

  5. "Hi Raghwendra,

    In the above example, presumably the answer you want is '3'?

    Please can you clarify:

    What answer would you want, if a row contained data in, say, Column B only (not Column C) for example?

    My general suggestion is to add a formula in Column D that creates a flag (0 or 1) indicating whether your criteria have been met. You can them sum that column.

    Hope that helps,

    Alan."

  6. "I have a spreadsheet that I would like to equip with a checkbox on each of 134 rows in 7 columns. I was able to get them working once but now they seem to lock up the spreadsheet and render it useless. (good thing I saved the original!) Anyway, I am an excel rookie so if you could give me any tips I'd really appreciate it!

    Thank you,

    Steve

    (by the way, awesome site, excel-ent advice. Sorry bout that one, really)"

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube