=AVERAGE(OFFSET(INDIRECT("A" & COUNTA(A:A)),-4,0,5))

Regards,
Ryan--

--
RyGuy


"Anu" wrote:

Please try =AVERAGE(OFFSET($A$2,COUNTA($A:$A)-6,0,5,1))

Anu

"bumpo" wrote:

Using Excel 2000.
I'm looking for a function that will look at a database , lets say, A1:A100
and take the average of the last 5 cells, A96:A100. When I add data to A101,
I want that same function to average A97:A101.