| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I calculate a running average?
Week 1 Week 2 Week 3
Cym M. Share 5.46% 4.63% 0 Cym TRX 130 110 ADD TRX 2,381 2,377 TRX Needed 129 128 Difference 1 -18 Total Needed -17 Avg SOM I want to calculate Avg SOM cell. I eter new data each week and want a running average of Cym M. Share. I can't figure it out how to make it work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I calculate a running average?
Assuming your first Cym M. share is in B2:
=AVERAGE($B2:B2) then copy across the columns. "JBilly" wrote: Week 1 Week 2 Week 3 Cym M. Share 5.46% 4.63% 0 Cym TRX 130 110 ADD TRX 2,381 2,377 TRX Needed 129 128 Difference 1 -18 Total Needed -17 Avg SOM I want to calculate Avg SOM cell. I eter new data each week and want a running average of Cym M. Share. I can't figure it out how to make it work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate running average but not count a zero. | Excel Worksheet Functions | |||
| running average | Excel Discussion (Misc queries) | |||
| running average | Excel Discussion (Misc queries) | |||
| Running Average | New Users to Excel | |||
| Running Average | Excel Discussion (Misc queries) | |||
Linear Mode
