Function for Cumulative Average?

[Stu]

I have a column of numbers, and in each cell next to that column I wish to
show the cumulative average. My data column is D, so in E3 I would have have
=SUM(D23)/2 and in E4 I would have =SUM(D24)/3, etc. How would I set
that up without having to type a formula in each cell in column D ?

 

[Stu]

Works! Thanks much!

try
in E2 '=AVERAGE($D$22)' and copy down
Sandy

 

[Sandy]

your welcome
Sandy

Works! Thanks much!

 

[Saleh Alkhatib]

Hi,

Where is the solution to that problem. I can't see what formula you used.

 

[joeu2004]

Where is the solution to that problem. I can't see what
formula you used.

Do you really think that Stu is still paying attention 2.5 years
later?!

Anyway, the solution is to put the following into E3 and copy down:

=AVERAGE($D$23)

 

[joeu2004]

Anyway, the solution is to put the following into E3 and
copy down:
=AVERAGE($D$23)

Better, put the following into E3 and copy down:

=IF(ISNUMBER(D3),AVERAGE($D$23),"")

 

[fawad zafar]

use the formula average($D$2:d3) and the click the bottom right corner to expand it to desired number of observations