COUNT
Counts the amount of number values in specified cells.
Syntax
=COUNT(Value1, [Value2...ValueN])
Arguments
Name | Type | Description |
---|---|---|
Value1 | Range | Cell range or reference range in which number values should be counted. |
Value2...ValueN (optional) | Range | Other cell references or ranges to check. |
Return
Type | Description |
---|---|
Number | Amount of number values. |
Examples
| |A|B| ||---|---|---| |1|2|| |2||4| |3|1|3|
Formula | Result | Comment |
---|---|---|
| 3 | Empty cells are not counted. |