Originally Posted by
joeu2004
=SUMPRODUCT((A1:A7 - AVERAGE(A1:A7)), (B1:B7 - AVERAGE(B1:B7))) / COUNT(A1:A7)
That presumes that all of A1:A7 and B1:B7 are numeric values. And of course, COUNT can be replaced by 7, in this case.
But COVAR ignores empty cells and text; in fact, COVAR includes only rows where both values are numeric. If you need that degree of compatibility, array-enter (press ctrl+shift+Enter, not just Enter) the following:
(Assumes that there is at least 1 row with a pair of numeric values.)
Bookmarks