COUNT function

Category: Statistical functions

What does this function do?

Count the number of cells in a range that contain numbers.

Syntax:

COUNT(value1, [value2], ...)

• 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.

Examples:

=COUNT(A1:A3) = 2 if A1:A3 = {2, A, 4}
=COUNT({1,"E",3}) = 2