Home Budget Question

[jeffj318]

Hello

I have a simple home budget set up to show my income and my monthly
expenses in excel. This works fine. What I am trying to do is show
the intermintent categories and how when I add or subtract more money
to them it will show the correct amount to the right of the monthly
expense.

Example: cell A-29 is Term Insurance in the monthly amount of $52 which
shows in cell B-29. I want to add another $52 to the next month to
show the total in cell C-29 or whatever cell is appropriate. How do I
accomplish this task? Instead of adding money will I be able to
subtract money when the time comes to do that?

Thanks for your help,
Jeff

 

[Wiley]

Please privde some clarification. In you example, why not just type $52 in
C29? You could create a formula in C2 that says
=B2+52
which will add 52 to B2. But is that what you are looking for?

 

[Jeff]

Hi Wiley - Almost what I want. I want to add any amount or subtract
any amount for the category. Example B26 is the Christmas cell and
each month I put in $50. I need some cell to show me the running total
as I continue to add $50 each month. So in three months I should be
showing $150 in some cell. When I go to deduct money from the total
amount I need to show what remains in the Christmas category. Does
this make sense and is it doable? Thanks, Jeff

 

[Wiley]

Use col A for a description. Then add a date column. Then set up budget
category columns to its right (one for each category you want to track).

For every addition or removal of money from a category, enter the desc and
date on the next available row. (enter a minus for money you want subtract)

For a running total, use the AutoSum button to highlight all the cells above
your total row in the category column. Do this for each category column.
See Excel Help for AutoSum or Add Numbers for a more thorough explanation.

When you need to add moer lines, highlight the total row and right click.
Select insert. This will include the new lines in your totals summation.

It seems as if you are a new user. Head to the bookstore and find a basic
book on using Excel with lots of tutorials. You will learn so much more
about the power and ease of Excel than posting on forums. I learned years
ago using a book I think was called Excel for Idiots.

Happy Learning!