Monthly Budget Percentage of Actual Budget Calculation

[m00]

I was inspired by this, and made one for the Savings Budget sheet as well. You can do Budget or Actual.

Percent of Budget in Savings Budget sheet. (Like it is displayed in Monthly Budget sheet.)

[budgetPercentage3] I saw a nifty feature in the Monthly Budget sheet, that showed each section as a percentage of the total budget. I was immediately envious, as I use the Savings Budget sheet, and it does not have that feature. So I made a formula that you can stick in the first “black bar” in the empty column (‘C12’ for me) of your Savings Budget sheet. Percentage of Budget for Savings Budget sheet =ARRAYFORMULA(IF(N12:N="Expense",TEXT(E12:E/INDIRECT("E"&MATCH("EXPENSE",B1:B,0)),"0%")&" …