skipping columns part 2
Earlier, I asked how I could skip columns, and was answered in the
following manner:
On cell A700 type
=AVERAGE(OFFSET($E$3,0,COLUMN()*7-7,648))
aand copy it across B700 and so on .
Now I am asking if I can use the above with an array formula. My data
is 'raw data'!e3:e650 and 'raw data'!f3:f650. I would like to simply
divide the two columns and get an average, and can do so using an array
formula:
{=average((e3:e650)/(f3:f650))
My question is how can I do this calculation on a different sheet, using
OFFSET as above. I have tried,
{=AVERAGE(OFFSET('raw
data'!$E3,0,COLUMN()*7-14,648))/AVERAGE(OFFSET('raw
data'!$F3,0,COLUMN()*7-14,648))},
but the value given is incorrect.
Any help is appreciated.
Wazooli
P.S. - I had to modify the above OFFSET formula to read
"...COLUMN()*7-14...", instead of "...COLUMN()&7-7..."
|