Setting up a continually updating average

[KirbyCTB]

I enter data on a daily basis. There is one column on a particular
worksheet in which I need a running average -- that is, average the
column, and when I enter new data, instantly update the average, so my
average is always up-to-date -- automatically.

I'd love to know how to set this up.

A second question:
How can I apply this formula or function of a continuous update
average to a portion of a column, instead of the whole column? I can
identify the starting cell, but the ending cell will change every time
I enter data.

Thank you very much.

 

[Don Guillett]

Use a defined name range.
Insert>name>define>name it something like myavgrng>in the refers to box
=offset($a$8,0,0,counta($a:$a)-8,4)
test by f5>type in the rgn name. Then just average that.

 

[Guest]

Let's say your are adding data to column E. The formula:
=AVERAGE(E:E)
will average the data you have entered. It will ignore blank cells and not
treat them like zero. As you add data to column E the function will updte
automatically