Hi,

If you want to include every new row in the average formula, then you may
convert the range to a List/Table (Ctrl+T). Select the entire range
(including the header row) and press Ctrl+T. When you convert a range to a
Table, it auto expands in every formula in which the range ie being used in
the workbook

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"iamjbunni" wrote in message
...
I have a formula that calculates averages each week. I need a formula
that
automatically uses the cell below when new data is entered.