Count

Counts the number of non-empty numerical cells in a value set.

Syntax

Count(param1, param2, ...)
Nb(param1, param2, ...)
param1 = first parameter in the set (value, range, or list)
param2 = second parameter in the set (value, range, or list)
... = nth parameter in the set (value, range, or list)

Remarks

This function accepts an unlimited number of parameters.

If you also want to count non-empty, non-numerical cells, see CountVal.
To also count the empty cells, see CountCells.

Examples

Count(2, "abc") = 1
Count(2, 3) = 2
Count(A1:B3) = 6 if none of the cells in the A1:B3 range is empty and all of them are numerical

Classification

Maths Ranges Statistics