Microsoft Office Tutorials and References
In Depth Information
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. ■
The equation for the correlation coefficient is
If the cells contain text,
logical values, or are
empty, they are ignored.
Cells containing zero
(0) are included in the
COUNT counts the number of cells that contain numbers within the list of arguments.
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.