Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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..." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Skipping and protected cells | Excel Discussion (Misc queries) | |||
Auto Skipping and Protecting Worksheet | New Users to Excel | |||
skipping columns | Excel Worksheet Functions | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
ALLOW ROW 1 AS HEADER ROW... NOT PART OF DATA SORT OF ANY COLUMNS. | New Users to Excel |