The COUNT function returns the number of its arguments that contain numbers, numeric expressions, or dates.
COUNT(value, value…)
value: Any value or a collection containing any values.
value…: Optionally include one or more additional values or collections.
Examples |
|---|
The information in the following table is not meaningful, but is useful to illustrate the type of arguments COUNT includes in its result. Given the following table: |
A | B | C | D | |
|---|---|---|---|---|
1 | 100 | 200 | 300 | 400 |
2 | lorem | ipsum | dolor | sit |
3 | 100 | 200 | 300 | sit |
4 | TRUE | TRUE | FALSE | FALSE |
5 | 200 | 400 |
=COUNT(A1:D1) returns 4, because all arguments are numeric. =COUNT(A2:D2) returns 0, because none of the arguments are numeric. =COUNT(A3:D3) returns 3, because the last cell is not numeric. =COUNT(A4:D4) returns 0, because the arguments are boolean TRUE or FALSE, which are not counted as numeric. =COUNT(A5:D5) returns 2, because two cells are empty. =COUNT(2, 3, A5:D5, SUM(A1:D1), “A”, “b”) returns 5, because the arguments 2 and 3 are numbers, there are 2 numbers in the collection specified by the range A5:D5, the SUM function returns a number, and the last two arguments are text, not numeric (altogether 5 numeric arguments). |
Example—Survey results |
|---|
To see an example of this and several other statistical functions applied to the results of a survey, see the COUNTIF function. |