I 12 rows of data, each row requires the rolling average.

"Biff" wrote:

Hi!

Is the range going down a column or across a row?

Biff

"Bearcats_85" wrote in message
...
i am trying to average the smallest 7 numbers out of the last ten entered
(i
can to work if all ten cells have data), how do i handle blank cells so i
still look at ten cells of data. The data is entered per day and if a day
is
missed i want to ignore and average with the last ten days data was
entered