| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average values in only last 6 columns
I have a sheet with data in columns.
The field starts in D2 and continues column by column with a new column each week. Currently data is populated through AL2 but will continue all the way to CL2. In CN2 I need a formula that will calculate the average of the last 6 entries. Currently that would be AG2:AL2 but next week that would need to be AH2:AM2 and so one. The columns will populate as data loads and I need this dynamic average to automatically update. Your assistance is greatly appreciated Don Flak |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| average values in non-contiguous cells, ignoring 0 values | Excel Worksheet Functions | |||
| Average AM or PM values | Excel Discussion (Misc queries) | |||
| Looking-up Columns w/calc'd Values ONLY to Calculate Average | Excel Worksheet Functions | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
Threaded Mode
