How to get a continuous average as data is added?
I have a sheet with one column of numbers. As numbers are added the average of all numbers up to that point are averaged. I cannot figure out how create one column formula to make that happen. I am trying to avoid fixing every cell.
Tx,
~Sarah
Answers
-
Hi @s.powers,
You should be able to do this fairly easily:
=AVG(Column:Column)
Adding some additional values:
Obviously just change the column name in the formula - my best guess is that you have selected a range and probably have some numbers in your current formula. If you remove these, the whole column rather than just the selected rows will be used.
Hope this helps, but if I've misunderstood anything or you've any problems/questions then just let us know!
-
I guess I also need to add, that I don't want the original value to change. The average column should be a new number each time adding in the new data from the Mean column.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!