Assuming A1 has a label and there are no empty cells in the column of
numbers below:
This finds the average of the last 20
=AVERAGE(OFFSET($A$1,COUNTA(A:A)-1,0,-20,1))
and this finds average of the smallest 10 in the last 20
=AVERAGE(SMALL(OFFSET($A$1,COUNTA(A:A)-1,0,-20,1),{1,2,3,4,5,6,7,8,9,10}))
I expect {1,2,3...} could be replaced by ROW(something) but I had no luck
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Tom" wrote in message
...
I have a continuing list of numeric entries. At any one time I want to be
able to cvalculate the average of the lowest 10 of the most recent 20
entries. I'm using Excel 2002.