Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average of absolute values of moving ranges
I'm trying to get the average of the absolute values of a set of data over 8
weeks. Each week is on a seaparate sheet so to capture the moving ranges I've been using the formula below to get my result. Is there an easier way? =AVERAGE(ABS('Week 1'!G2-'Week 2'!G2),ABS('Week 2'!G2-'Week 3'!G2),ABS('Week 3'!G2-'Week 4'!G2),ABS('Week 4'!G2-'Week 5'!G2),ABS('Week 5'!G2-'Week 6'!G2),ABS('Week 6'!G2-'Week 7'!G2),ABS('Week 7'!G2-'Week 8'!G2)) Thanks! Amy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
absolute ranges | Excel Discussion (Misc queries) | |||
average absolute values | Excel Discussion (Misc queries) | |||
Absolute formula moving | Excel Discussion (Misc queries) | |||
Absolute formula moving | Excel Worksheet Functions | |||
Making Sum ranges Absolute | Excel Discussion (Misc queries) |