how do i set up a moving average in Excel

P

p-nut

i am trying to set up a 7 day running average and cannot figure out how to do
it? Any help would be greatly appreciated.
 
B

Bernard Liengme

Hope I understand the Q
You have numbers in A1:A20 and will be adding more
In B7 enter =IF(ISNUMBER(A7),AVERAGE(A2:A7),"")
Copy down the column
This finds the average of the preceding seven numbers in A, provided there
is a value next to it
best wishes
 

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
Section and Page numbering 0
how do I set up a moving average in Excel 1
Slideshow with black border around it 0
Wrapping and Anchors 0
Set up and printing a 4-up mail merged postcard 0
Excel Issue with "Average" showing in Status Bar 2
Trying to find additional ranges outside of min, max, and average 2

Top