Is there a formula that will look at the last 6 non blank number values in a
range, and return the average of the four lowest? The numbers are in a row
that is 16 columns and the numbers are added per division weekly. Looks like
this:

45 43 44 45 51 58 38 49 52 38 60 59 41 65 50

Where the large spaces are blank cells, in this example I am looking for the
average of 59, 41, 38, 50. Ideas?