| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating average with moving startpoint
Consider the attached issue. I calculate average values for a list of units. How would you advise to calculate the averages, without having to manually move the starting point, every time when a new unit is listed? Thus how does =AVERAGE($B$2:B7) move to =AVERAGE($B$8:B8)?  +-------------------------------------------------------------------+ |Filename: Book1.zip | |Download: http://www.excelforum.com/attachment.php?postid=4925 | +-------------------------------------------------------------------+ -- broer konijn ------------------------------------------------------------------------ broer konijn's Profile: http://www.excelforum.com/member.php...o&userid=34402 View this thread: http://www.excelforum.com/showthread...hreadid=554626 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating moving average | Excel Worksheet Functions | |||
| Moving Average projection? | Excel Worksheet Functions | |||
| 30 Day Moving Average Ignoring Blank Cells | Excel Worksheet Functions | |||
| calculating moving average | Excel Worksheet Functions | |||
| Plotting moving average line on a chart | Charts and Charting in Excel | |||
Threaded Mode
