Fill options

[gio64]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have the following problem:
I have a section of my spreadsheet where I have sets of 3 values for which I need to write the average.
I have the average value in another area of the sheet. I have all the average values lined up in one row, one after the other.
If I write the average formula for the first set of 3 values and then I do a fill right, instead of putting in the second cell the average of the second set of 3 values, it places the average of the second, third and fourth values. Is there any way to have the fill command fill "skipping"3?
Thank you

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I have the following problem:
I have a section of my spreadsheet where I have sets of 3 values for which I
need to write the average.
I have the average value in another area of the sheet. I have all the average
values lined up in one row, one after the other.
If I write the average formula for the first set of 3 values and then I do a
fill right, instead of putting in the second cell the average of the second
set of 3 values, it places the average of the second, third and fourth
values. Is there any way to have the fill command fill "skipping"3?

If I understand you correctly, you have something like:

A B C D E F G H I
1 10 2 5 7 3 9 11 6 8

and you want the results to be


AA AB AC
100 5.666666667 6.333333333 8.333333333

If so, then one way:


AA100: =AVERAGE(OFFSET($A$1,0,3*(COLUMN()-COLUMN($AA$100)),1,3))

which you can then fill right.