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

--
Regards
Frank Kabel
Frankfurt, Germany
"gunther" schrieb im Newsbeitrag
...
can I set up a column B that will give me the average of last 10 entries
in
column A. Give formula.