Returns the number of cells that contain numbers in the values given as its argument(s).

Count syntax

=COUNT(Value, ...)

Argument Argument description
1Value Either a value or a range/array of multiple values.
2Any 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.


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.


What happens with a count over empty cells, text or errors?

The count function will simply ignore empty cells, text and errors.