need some Excel help

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
49,290
5,838
136
using Excel XP, trying to make a financial chart.

the columns are:

Date | Income | Income Source | Spending | Reason | Total

Basically, every time I spend something or make something, I want to add it in. Then, when I add something new, I want the previous total to be added in. That way, I always know how much $$ I actually have.

Anyway, how do you do the math for that within Excel?

 

SuperPickle

Golden Member
Nov 1, 2001
1,256
0
0
If your columns are setup A-F with the titles you have above in row 1:
Skip row two (hide it)
In the Total column F (cell F3) write the formula "=F2+B3-D3" without quotes.
Autofill that cell downward (grab the little square dot at the lower-right of the highlighted cell F3)
All this is doing is taking the previous balance in the 'total' column from the cell above, adding and income and subtracting any expense.
 

Kaido

Elite Member & Kitchen Overlord
Feb 14, 2004
49,290
5,838
136
Originally posted by: SuperPickle
If your columns are setup A-F with the titles you have above in row 1:
Skip row two (hide it)
In the Total column F (cell F3) write the formula "=F2+B3-D3" without quotes.
Autofill that cell downward (grab the little square dot at the lower-right of the highlighted cell F3)
All this is doing is taking the previous balance in the 'total' column from the cell above, adding and income and subtracting any expense.

Is there a way to auto-fill ALL the F spots? I've only figured out how to do the drag and fill thing. Thanks for the help!
 

SuperPickle

Golden Member
Nov 1, 2001
1,256
0
0
Originally posted by: Kaido
Originally posted by: SuperPickle
If your columns are setup A-F with the titles you have above in row 1:
Skip row two (hide it)
In the Total column F (cell F3) write the formula "=F2+B3-D3" without quotes.
Autofill that cell downward (grab the little square dot at the lower-right of the highlighted cell F3)
All this is doing is taking the previous balance in the 'total' column from the cell above, adding and income and subtracting any expense.

Is there a way to auto-fill ALL the F spots? I've only figured out how to do the drag and fill thing. Thanks for the help!
If you have the formula written in F3, copy that cell. Then highlight F4 through F65536 (or down as far as you want to go) and then paste. Excel will adjust the formula accordingly in all of the selected cells.