Formulas and Functions

Table Of Contents

COUNT

The COUNT function returns the number of its arguments that contain numbers,

numeric expressions, or dates.

COUNT(value, value…)

Â value: A value. value can contain any value type.

Â value…:Optionally include one or more additional values.

Usage Notes

To count any cell that contains any type of value (that is, any cell that is not empty), Â

use the COUNTA function.

Examples

The table in this example is used to illustrate all variations of the COUNT function. The information is

not meaningful, but does illustrate what type of arguments each variation of COUNT includes in the

function result.

=COUNT(A1:E1) returns 5, as all arguments are numeric.

=COUNT(A2:E2) returns 0, as none of the arguments are numeric.

=COUNT(A3:E3) returns 3, as the least two cells are not numeric.

=COUNT(A4:E4) returns 0, as the arguments are logical TRUE or FALSE, which are not counted as

numeric.

=COUNT(A5:E5) returns 2, as three cells are empty.

=COUNT(2, 3, A5:E5, SUM(A1:E1), “A”, “b”) returns 5, as the arguments 2 and 3 are numbers, there are

2 numbers in the range A5:E5, the SUM function returns 1 number, and the last two arguments are

text, not numeric (altogether 5 numeric arguments).