Setting up a continually updating average
 

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.

Setting up a continually updating average
 

Use a defined name range.
Insertnamedefinename it something like myavgrngin the refers to box
=offset($a$8,0,0,counta($a:$a)-8,4)
test by f5type in the rgn name. Then just average that.

--
Don Guillett
SalesAid Software

"KirbyCTB" wrote in message
oups.com...
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.

Setting up a continually updating average
 

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
--
Gary's Student
gsnu200712