Hi!

You don't need the array brackets inside Indirect. In fact, you don't need
Indirect at all.

=AVERAGE(SMALL(A1:A10,ROW($1:$7)))

Also, this only averages based on the range size and not on the number of
values inside that range. This would be better suited if the range didn't
contain any empty cells.

Biff

"RagDyer" wrote in message
...
Since you stated that the missing days are *BLANK*, and *NOT* zero, with
the
data list in Column A, try this *array* formula in B1, and copy down as
needed:

=AVERAGE(SMALL(A1:A10,ROW(INDIRECT({"1:7"}))))

--
Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of
the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



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