Excel - Average of last 10 rows

[Dnyan]

I have Excel file and I always calculate Average of last 10 rows.
But when I add some rows then again I have to calculate this formula for last 10 rows.

So, is there any formula who calculated Average of Last 10 rows.
Please help me about this.

Dnyan

 

[AlphaFrog]

This will average the last 10 rows in column A assuming no blank cells in between values.

=AVERAGE(OFFSET(A1,COUNTA(A:A)-10,,10))

 

[Dnyan]

This will average the last 10 rows in column A assuming no blank cells in between values.

=AVERAGE(OFFSET(A1,COUNTA(A:A)-10,,10))

Hi,

Thank you very much its working properly.

Thanks again
Dnyan

 

[AlphaFrog]

You're welcome.