Formula to autofill with an evenly spaced increment of rows?

Hi,

Could one of your Excel gurus please let me know how to write a formula to
autofill cells in a row from an average of two cells in a row, i.e., B1:B2,
B3:B4, B5:6... to A1, A2, A3...?

Thanks,
FormulaChalenged

Hi!

Try this in A1:

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

Copy down as needed.

Biff

"FormulaChallenged" <[email protected]> wrote in
message news:[email protected]...
> Hi,
>
> Could one of your Excel gurus please let me know how to write a formula to
> autofill cells in a row from an average of two cells in a row, i.e.,
> B1:B2,
> B3:B4, B5:6... to A1, A2, A3...?
>
> Thanks,
> FormulaChalenged
>
>
>