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:

*Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Determine the Number of Blank Cells.*

Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.