Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | October 29, 2024
Average the Largest 3 Values from the Last 5 Rows
=AVERAGE(LARGE(TAKE(B3:B12,-5),{1,2,3}))
For earlier versions of Excel...
=AVERAGE(LARGE(INDEX(B3:B12,ROWS(B3:B12)-5+1):B12,{1,2,3}))
Based on the sample data, the formula returns 76.33.
Sample Workbook: Download