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.|
Try it for yourself
Use the count function in cell A7 and apply it to cells A1 to A5 in the spreadsheet editor below.
Note that you can click the Show Answer button to look at the answer if you cannot figure it out.
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.