Donate SIGN UP

Formula in Excel

Avatar Image
johnny7 | 11:20 Fri 01st Aug 2008 | Computers
3 Answers
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?
Gravatar

Answers

1 to 3 of 3rss feed

Best Answer

No best answer has yet been selected by johnny7. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
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
Question Author
cool, thanks phil
Let me know if you get stuck

1 to 3 of 3rss feed

Do you know the answer?

Formula in Excel

Answer Question >>