I am trying to calculate my monthly average expense for a category as time passes and currently using the formula:
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 increases as the month progresses.
Is there one that will more accurately give me my average monthly expense? Possibly only including fully completed months or should I include the partial month to get my monthly average?