Hi,

Average is clever enough to ignore empty cells so why not

=AVERAGE(A:A)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"iamjbunni" wrote:

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