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