On Jul 9, 3:25 pm, "James Silverton"
wrote:
wrote on Mon, 09 Jul 2007
12:10:21 -0700:

j Hi,
j I figured out how to get an average of a column of numbers
j using the AVERAGE function, yet I cannot figure out how to
j get a running average when a new number is added. Please
j help. Thank you,
j Jill

Numbers in, say, A1:A35,
Overall average in B35, say, =AVERAGE(A$1:A35) Just pull the
cell down to new line to expand the range.
5-point, say, moving average in C35, =AVERAGE(A31:A35) Extend
similarly; the absence of $ allows both cell numbers to
increment.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.verizon.not

Hi James, thank you. When I copied the formula down to B36 it changed
from A1:A35 to A2:A36. How would i get it to include A1 as well and
not start at A2?
Thank you. Jill