| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automaticly changing average function target cells
I am looking to create a function to only average the last 6 entries in a
list of numbers w/out changing the target cells of the AVERAGE function on a monthly bases. Example: I want to track scores on a monthly bases but only want the average of the last six months worth of scores. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing average if cells populated | Excel Worksheet Functions | |||
| changing average calc if cells populated | Excel Worksheet Functions | |||
| changing color of values bigger or smaller than target | New Users to Excel | |||
| Changing target sheet name wihtin a macro | Excel Discussion (Misc queries) | |||
| How do I use an average function, not counting cells containing a | Excel Worksheet Functions | |||
Threaded Mode
