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

Average Calculation for Sunday School Year Long Goal 1
Help! How do I ignore blanks cells in an array? 3
how do i calculate a 4 week rolling average 1
How do I post date a letter? 1
Average Formula 2
How do I calculate an average if 2
Pivot Tabe- Add a calculate column 1
Help with Average formula 4

Top