#1
|
|||
|
|||
Formula that calculates cumulative averages
In the attached spreadsheet on the 2016 tab I need a formula in column J to take the average of the cell on the left for column I plus all the cells above it and give me an average. For instance, I need cell J3 to give me an average of cells I2 & I3. I would then need the next cell for J4 to give me an average for I2, I3 & I4 and so on. I can’t figure out how to make it do the cell to the left plus all the cells before it. Any help would be much appreciated. I would also like to know how/why a solution works so that I can figure it out for future use. Thank you in advance! |
#2
|
||||
|
||||
Change your formula in J3 from:
=AVERAGE(I2:I3) to: =AVERAGE(I$2:I3) and copy down.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
That did the trick. I can’t believe it was that simple. I kept looking for a “cumulative average” formula or something. It has been a long week… Thanks!
|
Tags |
average, average and sum, formula help |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Taking Averages with N/A's | lynchbro | Excel | 5 | 01-07-2015 10:42 AM |
Moving averages of data points with a changing sampling interval | jrosen | Excel | 3 | 10-23-2014 06:26 AM |
Enter a number in a locked equation within a cell that then calculates | Carchee | Excel | 7 | 06-13-2014 11:11 AM |
Chart: Cumulative line | tays01s | Excel | 1 | 02-18-2014 05:03 AM |
Formulas for cumulative value and cumulative %? | Brotein | Excel | 1 | 10-29-2013 05:35 AM |