bottom
Great ExcelTips!
         
Your e-mail address is safe!
Close Note

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!

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

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

 

Great Info!

Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your e-mail address and click "Subscribe."
     
(Your e-mail address will never be shared with anyone, ever.)