Returns the number of cells that contain numbers in the values given as its argument(s).
|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.|
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.
The count function will simply ignore empty cells, text and errors.