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

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?

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))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pat" wrote in message
...
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?

"Rob van Gelder" wrote:

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))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pat" wrote in message
...
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?


Rob, Thanks. What if I also want to include another column?

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))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pat" wrote in message
...


"Rob van Gelder" wrote:

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))

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Pat" wrote in message
...
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?


Rob, Thanks. What if I also want to include another column?