Creating a Budget

Hi,

I am trying to create an excel spreadsheet to track my spending, so that I can implement a monthly budget. In my first column I have my income and then in the succeding columns B-S, I have my spending categories (groceries, utilities, etc..). How do I set my formulas such that the spending category total will subtract from my income column. Also, if a particular column doesn't have any entries, it will not do any computing.

Thanks,

swb1

Can you post a workbook that illustrates what you want?

Please don't use the post icon for your threads -- you run the rask of having them inadvertently deleted, since spammers use them routinely ...

You can start w/ something like this... see the attached file.

Please note that the sum worksheet functions is set for the area B10:Q30

Regards,
nrage21

Thanks for the reply. I am attaching file of the spreadsheet that I was trying to create. The difference I see in the one's that you guys posted, was that I also wanted to track how much I spent in each column.

swb1

Was anyone able to look at the attachment that I sent?

swb1