Microsoft Office Tutorials and References

In Depth Information

**COUNT**

The number of data points in each array must be the same. If
array1
has 12 data

points,
array2
must also have 12 data points.
■

NOTE

The equation for the correlation coefficient is

where

and

Figure 11.7

If the cells contain text,

logical values, or are

empty, they are ignored.

Cells containing zero

(0) are included in the

CORREL
calculation.

COUNT

COUNT
counts the number of cells that contain
numbers
within the list of arguments.

=COUNT(value1,value2,...)

The
COUNT
function is used only to count the numerical entries in a range. Figure 11.8 shows a

comparison between the
COUNT
and the
COUNTA
functions.