COUNT Function. Number of numbers.

Japanese version.

The COUNT function obtains the number of numeric values in a specified cell range.

How it works

=COUNT(value1 to 255)
value1 to 255Required argument.
Cell range in which to count numbers.


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.


Microsoft Excel Functions Statistical

Other functions that count the number of cases.

COUNTA function.Get non-blank counts.

Examples of Use