Bob Phillips wrote:
"Bernard Liengme" wrote in message
...

=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


=AVERAGE(SMALL(OFFSET($A$1,COUNTA(A:A)-1,0,-20,1),ROW(INDIRECT("1:10"))))


ROW(1:10) seems to work as well as ROW(INDIRECT("1:10"))

Alan Beban