Hi

I have a range of data from C3 to C292 and I want to find the average of this data. I also want the average to update when new data is added to the rows below.

Eg

Date... Value
1/1/13...10
2/1/13...14
3/1/13...12
4/1/13....15

Average =

Then when data for the 5th, 6th and onwards are added, I want the average to change.

What is the formula?

Thanks,