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?