Average of lowest 3 of last 8 values

[johnchapman4]

I have a column with integer values. I want a formula what will display the average of the three lowest values our of the most recent 8 values, that can go in a parallel column. The most recent value will be on the same row as the value being determined. The rows above are progressively older values. The value calculated should be rounded to the nearest integer.

These are metrics that are captured periodically with only the most recent 8 considered relavant to the latest value being determined.

[johnchapman4]

I think I found the CSE function that I need:
=ROUND(AVERAGE(SMALL(G54:G61,{1,2,3})),0)

[Tony Valko]

No need to CSE.

Just a normal Enter will do.