Tips.Net > ExcelTips Home > Worksheet Functions > Statistical Functions > Counting the Number of Blank Cells
Counting the Number of Blank Cells
Summary: Do you want to know how many blank cells are within a range? You can use the COUNTBLANK function, described in this tip, to get the answer. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
One of the worksheet functions provided by Excel allows you to quickly and easily count the number of blank cells in a range. The format of the function is as follows:
= COUNTBLANK(range)
The function returns an integer value representing the number of blank cells in the range. You should be careful, however. If you have the display of zero values suppressed (on the View tab of the Options dialog box), a cell can appear blank, when it is not really blank. COUNTBLANK returns blank cells, not counting those that would have a zero displayed if you chose to display such values.
Tip #2157 applies to Microsoft Excel versions: 97 2000 2002 2003
Organize Your Data! Using the powerful sorting capabilities of Excel can help you get your data into just the order you need. Find out how you can use the full capabilities of sorting to your benefit.
Check out ExcelTips: Serioius Sorting today!
Perplexed by Pivots?
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site