COUNT

Counts the numbers in the specified cell, cells, and lists.

Syntax

COUNT( [Any value1], [Any value2], ... ) → Integer

Parameters

value1
value2
…

Zero or more items to include in the counting.

Remarks

Arguments that are numbers, dates, or text representations of numbers (such as "123") are counted. Logical values and text representations of numbers types directly into the list of arguments are counted. Error values are not counted and do not cause the function to return an error (that is, this function does not propagate errors). If an argument is an array or a reference, only numbers in that array or reference are counted. Empty cells, logical values, text, or error values are not counted. To count logical values, text, or error values, use the COUNTA function. To count only numbers that meet certain criteria, use the COUNTIF function.

If there are no arguments provided, the function returns zero.

Example

Formula

=COUNT(A1:B5)
=COUNT(3,"1",A1,B2:B5,{1;2})

See Also

Function Reference
COUNTA Function