<< Click to Display Table of Contents >> COUNT (number of cells filled with numbers)

Syntax:

COUNT(Range1 [, Range2, Range3 ...])

Description:

Counts the number of cells containing numbers. This functions counts only cells with numbers (including dates) and text representing a number.

Example:

If the cells A1:A3 contain 42, "Test" and TRUE and cell A4 is empty. The following applies:

COUNT(A1:A4) returns 1

For comparison: COUNTA(A1:A4) returns 3

Annotation:

The function COUNTA works similar, but it counts cells with any content

See also:

COUNTA, COUNTBLANK, COUNTP, FREQUENCY, ISBLANK, ISNUMBER, COUNTIF, COUNTIFS