You only need =AVERAGE(OFFSET(I6,9,0,10,1)), but irrewspective it works fine
for me as you describe it.

Can you give an example from I6 on that doesn't work.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Bruce" wrote in message
...
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