COUNT

Returns a count of the number of numeric values in a dataset.

Sample Usage

COUNT(A1:A25,B1:B20)
COUNT(1,2,3,4,5,C6:C20)

Syntax

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

value1 - The first number or range to consider when counting.
value2, .. - [OPTIONAL] Additional numbers or ranges to consider while counting.

Examples

COUNT(A1:A25,B1:B20) counts the number of cells that contain numbers in cells A1:A25 and B1:B20.

Notes

If you want to include logical values, text, and error values, use the COUNTA function.
COUNT counts all numeric values in a dataset, including those which appear more than once. To count unique values, use COUNTUNIQUE.