![]() |
|
#1
|
|||
|
|||
|
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!
|
| 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 |