MS Excel, spreadsheet formula.

James07

James07

James07

Soldato
Joined
6 Dec 2006
Posts
5,914
Location
West Yorkshire
Okay, ive decided, as a new years res, that im going to manage my finances much better so i know exactly where EVERY penny goes...

Now what i need to do is have a start balance, a weeks worth of activity which will total up in the box at the end, and there is a box at the side of that which will now tell me my new account balance.

Is there anyway i can use formulas to get this working, been a long time since i used this..

Is it even possible?



Cheers,

James.
 
Yeah but it isnt working..

I want to input my own data through the week and get a total at the end which will then add onto my account balance to make the actual balance on there the same on my account..

i cant explain this easily enough can i.. I dont know to put it..

Ill have a think and come back lol!!

EDIT: The sum isnt working either i.e. in cell N2 i want to add cells B to N.. so.. =SUM(B2+C2 etc..)

Isnt working..
 
Last edited:
I think the forumlae you need are:
N2 - =$C2-($D2+$E2+$F2+....) There's probably a quicker way to add across a row, but I'm not sure how, so it's easiest to just type them all out.
O2 - = $B2-$N2

If you put in the dollar signs, then you'll be able to use a fill for the rest of the sheet, anchoring the column but not the row.

EDIT: you also need to make B3 = $O2, and fill that down.
 
Put in a starting balance somewhere then just do sum's to calculate the total money made/lost during the week in the 'total' cell and add it to the initial balance in the account balance cell.
If you need help on specific formulas I'm sure you'll get an answer pretty speedily.

Editing: to sum across a row type in the cell =sum( then drag mouse over, or ctrl + click the ones you want to add)
Similarly you can say -sum() to subtract certain cells e.g. if they're outgoings not income.
 
Last edited:
You want column 0 to have your end of week account balance, so the end of week 1 will be the same as the start of week 2. Using the dollar signs just means you can fill the formulae you want. I've just tried the ones I suggested with your numbers and a random bank balance, and it seems to be working fine.
 
Vixen said:
You want column 0 to have your end of week account balance, so the end of week 1 will be the same as the start of week 2. Using the dollar signs just means you can fill the formulae you want. I've just tried the ones I suggested with your numbers and a random bank balance, and it seems to be working fine.
Click to expand...

Do you have msn? I could send you this..

Im having no luck with it at all.
 
James07 said:
Its doing what it was doing before, in N2 its coming up with ##### :confused: i can only assume this means there is an error with numbers.

but there isnt thats the thing.



I dont understand this bit?



Like the screenshot?
Click to expand...

1) You're number is too large to fit in the column. Make column wider as you have too large an income.
2) Making B3 = O2 means your starting balance for the following week will be your account balance from the end of the previous week.
3) Yup, like the screenshot, you just need to put all the formulas in.
 
Its all done now, all sorted, looking brilliant, sure will help me understand my finances now!!

Cheers to all who helped.
 
You must log in or register to reply here.
Back
Top Bottom