Returns the number of cells that contain numbers in the values given as its argument(s).
Count syntax
=COUNT(Value
, ...
)
Argument | Argument description | |
---|---|---|
1 | Value | Either a value or a range/array of multiple values. |
2 | … | Any number of more values or ranges/arrays of multiple values. Up to 255 can be given. |
Spreadsheet editor
Well done! You successfully used the COUNT function.
Explanation
You can use =COUNT(A1:A5)
to count the number of cells that contain a number. A1:A5 is the range of cells that we count. So cells A1, A2, A3, A4 and A5. Each of these cells contains a number, therefore the result is 5.
Questions
What happens with a count over empty cells, text or errors?
The count function will simply ignore empty cells, text and errors.