I have created a budget template for Personal use. Everything is working like I want it to EXCEPT two numbers are not matching. It's driving me crazy. The Checking Balance of $647.72 - $205.48 Credit Card Balance= $442.24. So why does the Budget Balance equal $453.33??? I have Quadruple checked all formulas, and Quadruple checked my numbers. I even tried creating a new worksheet, re-entering every number and I get the same problem.
This is the formula for Housing Amount:
=((SUMIF(Category,"Deposit",Suntrust Checking Acount :: Amount))*Percentage Housing)+(SUMIF(Category,$A2,Suntrust Checking Acount :: Amount))
Every Category has one equal to this except correctly changing the required cells. my percentages are to the 1000th, but equal EXACTLY 100%. attached is a picture of what it looks like to help visualize.
Thanks for any help. Have been working on this for 3 days now!
This is the formula for Housing Amount:
=((SUMIF(Category,"Deposit",Suntrust Checking Acount :: Amount))*Percentage Housing)+(SUMIF(Category,$A2,Suntrust Checking Acount :: Amount))
Every Category has one equal to this except correctly changing the required cells. my percentages are to the 1000th, but equal EXACTLY 100%. attached is a picture of what it looks like to help visualize.
Thanks for any help. Have been working on this for 3 days now!