Keeping the same reference range but placing the formula into a cell other than
B1.

=AVERAGE(OFFSET($A$1,ROW(1:1)*2-2,0,2,1))


Gord

On Tue, 11 Dec 2007 19:05:04 +0000, tpl wrote:


Thank you Gord! I was able to use the formula you provided and it was
beautiful. However, I was unable to change it so that I could move the
AVERAGE(OFFSET) formula to a cell other than B1 and still have the
reference range for the averages stay the same. Is there another trick
to this?

Thanks so much,

Tanya

Gord Dibben;597646 Wrote:
In B1 enter =AVERAGE(OFFSET($A$1,ROW()*2-2,0,2,1))

Drag/copy down until you get #DIV/0!


Gord Dibben MS Excel MVP

On Mon, 10 Dec 2007 17:41:55 +0000, tpl
wrote:
-

I have a long list of data listed as duplicate data points that need
to be averaged. For example, A1 and A2 are duplicates that need to be
averaged, A3 and A4 are duplicates that need to be averaged, etc. How
can I create an AVERAGE function and then fill it down so that it will
add 2 cells each time (as in =AVERAGE(A1+2),(A2+2) but this does not
work)? Thanks!-