MS Excel: Count Function
In Excel, the Count function counts the number of cells that contain numbers as well as the number of arguments that contain numbers.
The syntax for the Count function is:
Count( argument1, argument2, ... argument_n )
argument1, argument2, ... argument_n are either ranges of cells or values. There can be up to 30 arguments.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Count(A1:A6) would return 3 =Count(A1:A6, 129) would return 4 =Count(A1:A6, 129, "techonthenet") would return 4 =Count(A1:A6, 129, "techonthenet", -2) would return 5