Hello all
Infrequent visitor but you guys have helped me immensely in the past so I am ever hopeful. I have a set of numbers below which will keep being added to one number at a time. I need to set up a formula so it constantly updates the overall average of the last 6 numbers every time I update. For instance the average of the last 6 of the following numbers would be 12/6 = 2
Home Goals (FT)
0
1
2
2
2
1
2
0
3
3
But what is the formula so it constantly updates the last 6 numbers average clever people every time I add one?
Many thanks for your help,,,as always it is much appreciated.
Bookmarks