There may be instances in a Microsoft Excel 2003 spreadsheet where you allow a variable number of cells to have values, yet you need to determine how many values were actually entered.

For example, assume a Microsoft Excel 2003 spreadsheet where the user can enter values in column A from rows 1 to 10. However, not all rows must contain values:

**A1**: 23

**A2**: 11

**A3**: 45

Even though cells A4 through A10 are blank, formulas should be designed to handle this open-ended series of values.

Enter the **=COUNT** function. This displays the number of actual values that were entered into a series of cells.

Syntax:

**=count(SERIES)**

* SERIES is any series of cells in an Excel spreadsheet.

For example, adding onto the previous spreadsheet:

**C3**: =count(A1:A10)

This would result in the value:

**C3**: 3

*Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Count Number of Actual Arguments in a Series.*

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