Will there *always* be at least 6 numbers in the range? If not, then what
should happen?

--
Biff
Microsoft Excel MVP


"Pjmcc64" wrote in message
...
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?