COUNT Function. Number of numbers.
The COUNT function obtains the number of numeric values in a specified cell range.
Contents
How it works
=COUNT(value1 to 255)
| Name | Omission | Explanation |
|---|---|---|
| value1 to 255 | Required argument. Cell range in which to count numbers. |
Demonstrate
If non-numeric data are mixed in, they are ignored and counted.
Numbers treated as characters are also ignored.
Blanks, Boolean values, and errors are not included in the count.
Unlike the SUM function, the COUNT function does not error if errors are introduced.
If you want to count non-numeric numbers, use the COUNTA function.
The COUNTA function is probably used more often than the COUNT function.