Skip to main content

COUNT

Counts the amount of number values in specified cells.

Syntax

=COUNT(Value1, [Value2, ..., ValueN])

Arguments

NameDescription
Value1Cell range or reference range in whichnumber values should be counted.
Value2...ValueNOptional. Other cell references or ranges to check.

Return Value

Amount of number values.

Example

FunctionResultComment
=COUNT(A2:B4, 1)
3Empty cells are not counted.