| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
automatically average the last 4 columns
I am trying to figure out how to automatically average the last 4 columns in
a worksheet that every week adds a column. In other words, for "Prior4Weeks" on Sheet1, the formula would be =AVERAGE('Sheet2'!A5:D5) But then, a week later with another week's data summarized in a column added to Sheet2, the formula should read be =AVERAGE('Sheet2'!B5:E5) I know it's gotta be a macro, but don't know where to start. TIA, Greg |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
| repost: seeking help on how to automatically shift an average range as new data is added | Excel Discussion (Misc queries) | |||
| Find monthly average but have average automatically configured | Excel Discussion (Misc queries) | |||
| How to change average range automatically? | Excel Discussion (Misc queries) | |||
| Adding an Average line (from data sheet) to a chart automatically. | Charts and Charting in Excel | |||
Threaded Mode
