COUNT function

COUNT counts how many numbers are in the list of arguments. Text entries are ignored.

Syntax

COUNT(value1, value2, ...value30)

value 1, value 2, and so on are 1 - 30 values or ranges representing the values to be counted.

Example

The entries 2, 4, 6 and eight in the value 1-4 fields are to be counted.

=COUNT(2,4,6,"eight") = 3. The count of numbers is, therefore, 3.