|  

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

CATEGORY - Counting VERSION - All Microsoft Excel Versions
Assume Range A1:B15 (14 cells out of the 30 contain data)

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

The result: 16

Rate This Tip
12 34 5
Rating: 4.40     Views: 85544
How to get no of non empty rows in excel sheet.
Raghwendra  Posted on: 31-12-1969
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
Reply: How to get no of non empty rows in excel sheet - Raghwendra from Mumbai, India wrote on August 22, 2003 12:50 AM EST
Alan  Posted on: 31-12-1969
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.
Check boxes
Steve  Posted on: 31-12-1969
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)
Name
Comment Title
Comments