This is acceptable
Code:
=COVAR(A1:D1,E1:H1)
And so is this
Code:
=COVAR({3,2,4,5,6}, {9,7,12,15,17})
However, this isn't
Code:
=COVAR({A1,C1,E1,G1}, {B1,D1,F1,H1})
Any idea why?
Is it possible to have non adjacent cells in an array?