Change Row # by 2, Keep Column # Fixed

[scantor145]

I have the following formula in Cell G9, for example. It simply is averaging 2 numbers to the left cell G9

Please Login or Register  to view this content.

What I would like to do is now average the next 2 numbers in Column F with the result in cell G10. That is, the formula will be

Please Login or Register  to view this content.

The next formula in Cell G11 would be

Please Login or Register  to view this content.

etc.

I'm sure there's away to modify the formula in G9 such that when I drag down column G all the correct formulas will be copied.

[Jonmo1]

Try

=AVERAGE(OFFSET(F$9:F$10,(ROWS(A$1:A1)-1)*2,0))

[Pete_UK]

You can put this non-volatile formula in G9:

=AVERAGE(INDEX(F:F,ROWS($1:1)*2+7):INDEX(F:F,ROWS($1:1)*2+8))

then copy down as required.

Hope this helps.

Pete