Formula that calculates cumulative averages

		Microsoft Office Forums > Microsoft Excel > Excel
Formula that calculates cumulative averages

02-04-2016, 05:16 PM

macropod

Windows 7 64bit Formula that calculates cumulative averages

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

Change your formula in J3 from:
=AVERAGE(I2:I3)
to:
=AVERAGE(I$2:I3)
and copy down.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

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

Other Forums: Access Forums

All times are GMT -7. The time now is 05:17 PM.