Averaging every other cell

[asluiter]

I am trying to average cells 1 and 2 from my first page into cell 1 of the second page, then average cells 3 and 4 from the first page into cell 2 of the second page. It seems that the only way to do this is by hand, as fill down does not follow that pattern. Any suggestions? Thanks!

[swatsp0p]

In cell A1 of your second sheet enter the standard Average formula:

=AVERAGE(SHEET1!A1:A2)

in cell A2 of your second sheet enter this formula and then copy down as far as needed:

=AVERAGE(INDEX(Sheet1!A1:Annn,ROW()*2-1,,1),INDEX(Sheet1!A1:Annn,ROW()*2,,1))

Where the reference 'Annn' is the last row of data on Sheet1

Does this work for you?

Bruce

[asluiter]

Bruce-

Thanks! I had to lock my reference cells, but other than that it worked great. Thanks so much for the help! You saved me many hours of work.

Amie

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always appreciated.

Cheers!

Bruce