ExcelBanter - how do I calculate a running average?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I calculate a running average? (https://www.excelbanter.com/excel-discussion-misc-queries/262858-how-do-i-calculate-running-average.html)

JBilly

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.

Sean Timmons

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.

All times are GMT +1. The time now is 09:22 PM.