how do I set up a moving average in Excel

P

p-nut

I am trying to set up a 7 day moving average and cannot figure out how to set
it up? Any help would be great.
 
J

JLatham

Assume you have numbers to average in row 1, beginning at column 1 and going
across the sheet. At G2, enter this formula:
=AVERAGE(A1:G1)
and simply extend the formula to the right, it will automatically give the
average of the value above it and in the 6 cells to the right of that cell,
sliding as it goes.

Hope this helps.
 

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

I screwed up 0
Wrapping and Anchors 0
Set up and printing a 4-up mail merged postcard 0
Slideshow with black border around it 0
Move Chart with Text 0
how do i set up a moving average in Excel 1
Synchronization problems while moving folders to new email 1
Margins on Word document which will not let me move them using the ruler arrows 2

Top