Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am trying to calculate a cumulative average column on a table I'm making in Excel.

I use the totals row for the ending cumulative average, but I would like to add a column that gives a cumulative average for each row up to that point. So, if I have 3 rows I want each row to have a column giving the average up to that row and then the ending cumulative average in the totals row.

Right now I can't figure this out because I'd be having to reference in a formula rows above and below the current row and I'm unsure about how to go about it because it's a table and not just cells. If it was just cells then I know how to do the formula and copy it down each row, but being that the formula I need depends on whether or not a new row in the table is added or not I keep thinking that my formula would be something like:

(Completion rate row 1/n) where n is the number of rows up to that point, here row 1, then ((Completion rate row 1 + Completion rate row 2)/n) for row 2 so n=2, and so on for each new row added.

share|improve this question

2 Answers 2

up vote 0 down vote accepted

Try this (formula in G column):

=AVERAGE(INDIRECT("A2:E" & ROW()))

enter image description here

share|improve this answer
    
Tweaked this a bit and now it works flawlessly, thank you very much :D –  Aaron E Oct 17 '13 at 17:34

You can use the formula "mean" with the multiple selection on the three rows.

You can have the multiple selection by

  1. if the row are close you can have a selection as a matrix
  2. differently select the first row+CTRL then select the second row+CTRL the select the last row
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.