Array Function - Problem

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MATCH to ignore blank cells in array 3
Array formulas/selecting data 2
#DIV/0! error using Avgerage 15
Average IF Function 3
Average If Array Formula 4
Can the Excel RTD function return an array (It does on Bloomberg) 0
Quick Explanation 5
AVERAGE NON-ZERO CELLS ACROSS SEVERAL WORKSHEETS IN SAME WORKBOOK 7

Top