​​​​Count

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.

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.

​Get Good at Excel on Autopilot

Sign up to our newsletter and receive ​Excel articles, tips and tricks delivered straight to your inbox. All you have to do is read them! ​Plus, to get you started, you'll receive a PDF with 200+ Excel shortcuts.

>