How do I create 30 day running average

[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

 

[Guest]

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.

 

[Earl Kiosterud]

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.