COUNT

Get a count of cells that have numbers.

Parameter List

Syntax
COUNT(value1
[value2]
)
value1

A value, cell, or range in which to count the occurence of numeric values. For example: 32, A1, or A1:B5.

[optional] value2

Additional value, cell, or range in which to count the occurence of numeric values. For example: 12, A2, or C1:D5.

Examples

COUNT(A1:A5, 1, "Superman", B1:B5) returns 6, as cells A1:A5 have a number and the second parameter also contains a number.Example 1