Formula in Excel

[johnny7]

I want to keep track of how much money I'm spending and how much money I have left from my budget. I have a field for my budget and I add items I purchase everyday and their cost into the spreadsheet; is there a formula I can enter to automatically calculate the amount of money I have left everytime I add something that I have purchased without having to manually calculate the total amount spent and subtracting this from my budget?

[philg]

Yes there is - Excel is always easier if you take it one step at a time

I'd start with a mental picture of 2 columns

Column a (column A) is your budget

Put your budget amount in cell A3

In A1 put =sum(A3:A999)

Now, in cell A1 you will have your budget (which is the same as A3 BUT if anyone gives you money as a gift, you can add it to A4, A5 etc and the sum in A1 will automaticall update

Column C will be your expenditure

In C1 put =sum(C3:C999)

NOW, you can add your expenditures to C3, C4, C5 etc and the TOTAL of everything in column C will be in C1

SO

A1 is your total BUDGET
C1 is your total EXPENDITURE

In E1 put =(A1-C1)

Now E1 is how much of your budget you have left when you've subtracted your total expenditure

Hope this helps (and hope E1 always stays +ve!!)

Phil G

In

[johnny7]

cool, thanks phil

[philg]

Let me know if you get stuck