|
|
#1
02-04-2016, 03:05 PM
|
|||
|
|||
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!
|
|
#3
02-04-2016, 06:31 PM
|
|||
|
|||
|
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 |
Windows 7 32bit 
Office 2013
Linear Mode
