how do I calculate a running average?

J

JBilly

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.
 
S

Sean Timmons

Assuming your first Cym M. share is in B2:

=AVERAGE($B2:B2) then copy across the columns.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i calculate a 4 week rolling average 1
How do I calculate an average if 2
Calculate Count of Days & Average WHERE Amount <>0 1
Running Average 4
Help with Average formula 3
How do i Calculate minutes between two different dates 5
Running daily average 6
How do I keep a running average of a row in exce; 1

Top