Averageif bottom n if not blank
I’d like to find the average of the bottom n (3 in this case) of a range. These will be golf scores and updated weekly. It will be 3 weeks before I have 3 numbers in the range, but I will need an average before that too. Eventually there will be 9 numbers and I’ll want the average of the smallest 3. I guess it’s kind of like a running average.