O
Oscar Munero
Hi,
I have data in A2:A325, A2,A4,A6 etc represents length and A3,A5,A7 etc
represents breadth.
I am trying to calculate average length and average breadth, so I want to
just average A2,A4,A6 etc and seperately want to average A3,A5,A7 etc.
I've tried using the array formulas below but with little success, can
anyone point out where I'm going wrong or offer an alternative?
=AVERAGE(IF(MOD(A2:A324,2),"",A2:A324)) gives #DIV/0!
=AVERAGE(IF(MOD(A3:A325,2),A3:A325,"")) gives an answer I'm not sure is
correct
Thanks,
Oscar.
PS. I have used [Ctrl][Shift][Enter] to get {around array}
I have data in A2:A325, A2,A4,A6 etc represents length and A3,A5,A7 etc
represents breadth.
I am trying to calculate average length and average breadth, so I want to
just average A2,A4,A6 etc and seperately want to average A3,A5,A7 etc.
I've tried using the array formulas below but with little success, can
anyone point out where I'm going wrong or offer an alternative?
=AVERAGE(IF(MOD(A2:A324,2),"",A2:A324)) gives #DIV/0!
=AVERAGE(IF(MOD(A3:A325,2),A3:A325,"")) gives an answer I'm not sure is
correct
Thanks,
Oscar.
PS. I have used [Ctrl][Shift][Enter] to get {around array}