Forum Discussion
emmaballer
Jun 30, 2020Copper Contributor
Running Average
Help! I am creating a budget spreadsheet where I can enter my expenses for each month into a separate worksheet on excel. I would like to keep a running average cost of different expenses. I wa...
emmaballer
Jun 30, 2020Copper Contributor
Thank you mathetes. I will do some editing and see if I can make something similar to that work!
mathetes
Jun 30, 2020Silver Contributor
Feel free to post a copy of whatever you come up with if you continue to have questions. Part of the key to making that approach work dynamically is in having the ongoing expenses recorded in an Excel Table. And the same is true for the Budget Category list -- as you add things to it (or modify it), those changes are automatically included in Pivot Tables, etc, once you hit "Refresh"