How to calculate Covariance.P with #value?

Occasional Contributor

Hi! How do I calculate the covariance when the beginning of the data set has #value? 

See attached file below cell B208 

1 Reply



Values in AF207:AF410 are texts, don't know why. If convert to numbers, within COVARIANCE use arrays of the same size (they are different now) and eliminate errors, when


calculates something. I'm not familiar with stats to estimate is that correct result or not.

Please see in AJ2017 of the attached file.