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

by  About
       

Assume Range A1:B15 (14 cells out of the 30 contain data)

Use the following function: =COUNTBLANK(A1:B15)

The result: 16



6 thoughts on “Count the number of blank cells in a range in Microsoft Excel

  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 *


seven − 6 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>