What is the formula to sum the last ten entries in a row in an Ex.

P

Pat

I am trying to calculate a running average of the last 10 items I place in a
row. Is there an easy way to do this?
 
R

Rob van Gelder

Assumes your list starts in A1 and is contained in column A without any
gaps.

=AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10))
 
P

Pat

Rob van Gelder said:
Assumes your list starts in A1 and is contained in column A without any
gaps.

=AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10))
Click to expand...
Rob, Thanks. What if I also want to include another column?
 
R

Rob van Gelder

Assuming the columns are adjacent - by using the Width argument of Offset

This averages last 10 entries of columns A and B
=AVERAGE(OFFSET($A$1, COUNTA($A:$A) - 10, 0, 10, 2))
 
Top