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

Syntax:

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

Description:

This determines how many cells in one or more ranges are filled with numbers. This function only counts 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

Additional info:

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

See also:

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