COUNT function
Summary
Counts how many numbers are in the list of arguments
Syntax
COUNT(value1, [value2], ...)
The COUNT function syntax has the following arguments:
• value1 Required. The first item, cell reference, or range within which you want to count numbers.
• value2, ... Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.
Note: The arguments can contain or refer to a variety of different types of data, but only numbers are counted.
• value1 Required. The first item, cell reference, or range within which you want to count numbers.
• value2, ... Optional. Up to 255 additional items, cell references, or ranges within which you want to count numbers.
Note: The arguments can contain or refer to a variety of different types of data, but only numbers are counted.
Example
=COUNT(A2:A6)
=COUNT(A5:A6)
=COUNT(A2:A6,2)
=COUNT(A5:A6)
=COUNT(A2:A6,2)