I am trying to replace the range in an average calculation using the offset
function but its not giving me the result the same as using Excels standard
average function.

Say I want to;

=AVERAGE(I6:I15)

Therefore;
I want to dynamically adjust the rane using I6 as the reference point.
I figure that using I6 I need to adjust the rows by 9 (downwards) the cols
by 0. The overall height = 10 and the width 1.

So Iv'e tried;

=AVERAGE(OFFSET(I6:I6,9,0,10,1))

But it gives me a different answer and I cannot work out what range this is
actually an average of.

What should I do?

Bruce