Skip to main content
Version: Streamsheets 3.0

COUNT

Counts the amount of number values in specified cells.

Syntax

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

Arguments

NameTypeDescription
Value1RangeCell range or reference range in which number values should be counted.
Value2...ValueN (optional)RangeOther cell references or ranges to check.

Return

TypeDescription
NumberAmount of number values.

Examples

| |A|B| ||---|---|---| |1|2|| |2||4| |3|1|3|

FormulaResultComment
=COUNT(A1:B3, 1)
3Empty cells are not counted.