The following formula returns the number of blank (empty) cells in a range named Data:

=COUNTBLANK(Data)

The COUNTBLANK function also counts cells containing a formula that returns an empty string. For example, the formula that follows returns an empty string if the value in cell A1 is greater than 5. If the cell meets this condition, the COUNTBLANK function counts that cell.

=IF(A1>5,””,A1)

You can use the COUNTBLANK function with an argument that consists of entire rows or columns. For example, this next formula returns the number of blank cells in column A:

=COUNTBLANK(A:A)

The following formula returns the number of empty cells on the entire worksheet named Sheet1. You must enter this formula on a sheet other than Sheet1, or it will create a circular reference.

=COUNTBLANK(Sheet1!1:1048576)

• Excel How-to: The GETPIVOTDATA Function In a previous post, we created a simple pivot table from a list of Excel data.  Today, we'll link the...
• All signs are pointing toward an exciting US Open tournament. The summer of contentment surrounding Roger Federer has shown absolutely no signs of abatement today, as this brand new father...
• MetaStock Peak Functions Explained Watch this video for more MetaStock tips and tricks.The Peak function allows you to refer to a peak (i.e. distinct...
• Excel Tip: Have Your Cell Contents = Tab Names It's time for another edition of Stupid Excel Tricks! One of my coworkers recently asked me an Excel question.  He...
• USA - MS: Autologous Stem Cell Transplants, Visible Progress in 8 of 10 Patients Image via Wikipedia Transplanting stem cells from one’s own bone marrow (autologous stem cell transplants) improves the symptoms of muscular...