I am trying to calculate my monthly average expense for a category as time passes and currently using the formula: =C15/MONTH(TODAY()) C15 is my total running category expense for the year. This formula kind of works but is not very accurate as each month starts off with $0 expenses and then incre…

What is the best running monthly average equation?

Edward September 26, 2019, 1:26pm 5

Topic		Replies	Views
How to calculate "this month's expense" number from transactions tab Google Sheets how-to	4	773	March 10, 2020
Average per category per month Google Sheets how-to	7	873	March 18, 2020
Calculate monthly average in pivot table? Google Sheets how-to	3	2615	September 26, 2019
Monthly Budget Percentage of Actual Budget Calculation Google Sheets how-to , budgeting	7	1436	March 11, 2022
Review Last Month's Category Actuals in the Categories Sheet Show & Tell budgeting	2	802	September 9, 2021