Dear all,

I have a series of data in Column A

A
2
5
6
=average(a1:a9)
7

Cell A4 is the average from A1 to A5, in this case is 5
However, if I simply put this formula into A4, it obviously is an error.
What should be the formula then?

Thanks

Kent