K
Kent
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
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