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.
Examples:
Based on this table:
|
|
A |
|
1 |
OracleHome |
|
2 |
|
|
3 |
123xyz |
|
4 |
34 |
|
5 |
56 |
|
6 |
-78 |
123xyz would not be counted as it has text in it, unless added explicitly.
=Count(A1:A6)
would return 3
=Count(A1:A6, 129)
would return 4
=Count(A1:A6, 129, “OracleHome”)
would return 4
=Count(A1:A6, 129, “OracleHome “, -2)
would return 5
Count – Excel Function