A
ALANBATESON
I am trying to copy an array function which averages cells a1:a300 wit
some div/0 cells within due to no data, the array function works i
a302, and copies fine but it wont work in 3 out of the 8 summary cells
it works in a,c,d,e,g,k but in the others it justs pastes the value bu
the new array function with the right references is displayed. So th
correct array fn. is there but the value is not the value of th
average, it is the average of the previous range i copied it from
example a301 = array average a1:a300 = 456, copy a301 to b301, b301
array average b1:b300 = 456, when it should equal 543. Any help grea
some div/0 cells within due to no data, the array function works i
a302, and copies fine but it wont work in 3 out of the 8 summary cells
it works in a,c,d,e,g,k but in the others it justs pastes the value bu
the new array function with the right references is displayed. So th
correct array fn. is there but the value is not the value of th
average, it is the average of the previous range i copied it from
example a301 = array average a1:a300 = 456, copy a301 to b301, b301
array average b1:b300 = 456, when it should equal 543. Any help grea