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