In Google Sheets I would like to create a formula to look at my most recent past 20 scores in a column and averages the lowest 8 scores.
In another post I found the following formula that will average my 8 most recent scores. However, I need it to look at my most recent 20 scores and average the lowest 8.
Here was the formula I found:
=AVERAGE(QUERY(SORT(K3:K, ROW(K3:K)*ISNUMBER(K3:K),0),"select * LIMIT 8"))