| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I reference the last 3 cells in a row as cells are added
I am trying calculate a rolling three month average as each months numbers
are added. For example: If I have values for all the months up to July, I want to average May, June and July. When August is added I want it to average June, July and August. I have been doing this by changing the range in the formula each month, but would like to make it more efficient and user friendly. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To safety merge cells without data destroyed, and smart unmerge! | Excel Discussion (Misc queries) | |||
| Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
| 3 cells are named - how to refere to them in one reference field in a chart | Charts and Charting in Excel | |||
| GET.CELL | Excel Worksheet Functions | |||
| Using the results from two seperate cells to create cell reference | Excel Worksheet Functions | |||
Threaded Mode
