Function for Cumulative Average?

  • Thread starter Thread starter Stu
  • Start date Start date
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 ?
 
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)
 
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),"")
 
use the formula average($D$2:d3) and the click the bottom right corner to expand it to desired number of observations
 
Back
Top