Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
Description
The COUNT function counts the number of elements in a comma-separated list. It is useful for determining how many items are present in a given set of values.
Syntax
COUNT(value1, [value2], ...)
The COUNT function syntax has the following arguments:
- value1 Required. The first item to be counted.
- [value2, ...] Optional. Additional items to be counted, up to a maximum of 255 values.
Example
| Formula | Description | Result |
| =COUNT(1, 2, 3, 4, 5) | Counts the number of numeric values in the list. | 5 |
| =COUNT("apple", "banana", "cherry") | Counts the number of text values in the list. | 3 |
| =COUNT(1, "apple", TRUE, 3.5) | Counts the number of mixed values in the list. | 4 |
Errors
For a full list of formula errors, please read Formula errors.