Hey guys,

I'm attempting to use the =COVARIANCE.S function in excel, but I'm getting a #n/a because there are n/as in A:A and B:B but in different places, so in other words each array has a different number of data points.

Can anyone think of a formula that will modify the covariance function so that an #n/a in A:A will ignore both A:A and B:B for that data point? I.e. excel will ignore any row that has n/a in either A or B, and therefore make the number of data points the same.