Help with Budget Sheet

[LadyRogue]

So I'm trying to figure out how to set up a function to keep track of our money. Basically, I'm looking for a way to just insert the amount I put into the bank from my paycheck and then when we spend money, it automatically subtracts from the same cell (this way I keep track of what's in the bank)

I already have it set up so when I insert the amounts on one sheet, on another sheet it adds those amounts up depending on the category. For example, I have a category for each of our expenses so when I spend money on food, I type in how much I spend then type in 'food' as the category. Then on sheet1 it adds that to a running total for food. So... how can I have a category that adds up my deposits, but subtracts when any of our expense categories go up. Does that make sense? If not, I can upload a sample sheet for you all. Thanks!

[Oscargrouch]

So I'm trying to figure out how to set up a function to keep track of our money. Basically, I'm looking for a way to just insert the amount I put into the bank from my paycheck and then when we spend money, it automatically subtracts from the same cell (this way I keep track of what's in the bank)

I already have it set up so when I insert the amounts on one sheet, on another sheet it adds those amounts up depending on the category. For example, I have a category for each of our expenses so when I spend money on food, I type in how much I spend then type in 'food' as the category. Then on sheet1 it adds that to a running total for food. So... how can I have a category that adds up my deposits, but subtracts when any of our expense categories go up. Does that make sense? If not, I can upload a sample sheet for you all. Thanks!

Try This Planner http://www.moneysavingexpert.com/ban...udget-planning

[LadyRogue]

A good idea, but not what I'm looking for. This seems that it's more about figuring out a budget. I already have our budget figured out, I just want to keep track of it each month and I already have my monthly spreadsheet set up, I just need to figure out this one last column.

[Oscargrouch]

You would probably need to post your XL sheet.

[Richard Buttrey]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.