Function for Cumulative Average?

S

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(D2:D3)/2 and in E4 I would have =SUM(D2:D4)/3, etc. How would I set
that up without having to type a formula in each cell in column D ?
 
S

Saleh Alkhatib

Hi,

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

joeu2004

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

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$2:D3)
 
J

joeu2004

Anyway, the solution is to put the following into E3 and
copy down:
=AVERAGE($D$2:D3)
Click to expand...

Better, put the following into E3 and copy down:

=IF(ISNUMBER(D3),AVERAGE($D$2:D3),"")
 
F

fawad zafar

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