Please consider supporting this website by buying me a coffee.
Thank you for your consideration!
Updated | October 31, 2024
Average the Last 3 Values
The following formula returns the average of the last 3 values in B3:B12...
=AVERAGE(TAKE(FILTER(B3:B12,LEN(B3:B12)>0),-3))
For earlier versions of Excel...
=AVERAGE(INDEX(B3:B12,LARGE(IF(LEN(B3:B12)>0,ROW(B3:B12)-ROW(B3)+1),3)):B12)
Note that the formula needs to be confirmed with CTRL+SHIFT+ENTER. If done correctly, Excel will automatically place curly braces {...} around the formula.
Based on the sample data, the formula returns 71.67.
Sample Workbook: Download