Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Count Number of Actual Arguments in a Series

Summary: Display how many cells inside a series in an Excel spreadsheet actually hold data.

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

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

Last Modified on: July 13, 2008, at 12:04 A.M. EDT

Return to the Microsoft Excel 2003 Functions and Formulas page.

Print this tip.

- Subscribe!

Search the Site: