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

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′?

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′?

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