How do I create 30 day running average

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I track a daily and calendar month average of data. Would like to find a way
to have a 30 day running average populate each day in column C when I update
my daily average in column b. Any thoughts on how to do this. Thanks, Rob
 
Assuming you have one day per row and list every day, starting in C30 (since
there aren't thirty days prior to that) enter the following formula and copy
down:
=IF(B30<>"",AVERAGE(B1:B30),"")
It will, for each day that contains a daily average, give you the average of
last thirty days.
 
Rob,

This will give you the average of the 30 cells in column B, from B2 to B31.
=AVERAGE(B2:B31). Put it wherever you want. Then copy it down with the Fill Handle.
That's the button in the lower right corner of a cell. The next formula will be
=AVERAGE(B3:B32), and so on, giving you the average of 30 cells one cell down. I think
that's what you want.

--
Earl Kiosterud
www.smokeylake.com

Note: Some folks prefer bottom-posting. But if you bottom-post to a reply that's already
top-posted, the thread gets messy. When in Rome.
 
Back
Top