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...
Forum Discussion
Thank you mathetes. I will do some editing and see if I can make something similar to that work!
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"