» Count the number of blank cells in a range in Microsoft Excel
CATEGORY - Counting
VERSION - All Microsoft Excel Versions
Use the following function: =COUNTBLANK(A1:B15)
The result: 16
Book Store:
Recommended Books:
- The Intelligent Investor: The Classic Bestseller on Value Investing
- Marketing Plans That Work, Targeting Growth and Profitability
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- Keys to Reading an Annual Report (Barron's Business Keys)
- Windows XP for Dummies
- Special Edition Using Microsoft Office XP
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)
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
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