ChatterBank1 min ago
Formula in Excel
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?
Answers
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
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