Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | October 31, 2024
Average the Last 3 Rows
The following formula returns the average of the last 3 rows in B3:B12...
=AVERAGE(TAKE(B3:B12,-3))
For earlier versions of Excel...
=AVERAGE(INDEX(B3:B12,ROWS(B3:B12)-3+1):B12)
Based on the sample data, the formula returns 68.33.
Sample Workbook: Download