How do I create 30 day running average
 

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

How do I create 30 day running average
 

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 Moore" wrote:

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

How do I create 30 day running average
 

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.

-----------------------------------------------------------------------
"Rob Moore" wrote in message
...
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