Averaging every other cell

  • Thread starter Thread starter asluiter
  • Start date Start date
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
 
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
 
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
 
I'm glad it worked for you. Thanks for the feedback, it is alway
appreciated.

Cheers!

Bruc
 
Back
Top