Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Determine the Number of Blank Cells

Summary: Use the countblank function to determine the number of cells in a range that are blank.

If you need to determine how many blank cells exists in a range in a Microsoft Excel 2003 spreadsheet, the =countblank function makes this task easy.

=countblank(RANGE)

RANGE is a range of cells to scan.

For example, assume the following spreadsheet of a person's yearly sales report, broken down by quarter. The spreadsheet will notify the end-user of how many more entries are needed before, presumably, calculations can occur with the data.


A B
1 1st Quarter 23
2 2nd Quarter
3 3rd Quarter 45
4 4th Quarter 28
5
6 ="Values Required: " & COUNTBLANK(B1:B4)

The result:

B6 Values Required: 1

Add: Del.icio.us | Digg | Furl | My Yahoo!

Last Modified on: August 4, 2008, at 8:43 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: