Averaging every other cell

A

asluiter

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

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
 
A

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
 
S

swatsp0p

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

Cheers!

Bruc
 
Top