Article updated on March 29, 2018

The COUNT function counts all numerical values in an argument, it allows you to have up to 255 arguments.

Blank cells, boolean values and text values are not counted. It differs from most other functions, ignoring error values.

Formula in cell D3:


Excel Function Syntax

=COUNT(value1, [value2], ...)


value1 Required. A cell reference, array or constants for which you want to count numbers.
[value2] Optional. Up to 255 additional arguments.