subtract amounts from different columns?

[Guest]

I have 3 columns with, income, expenditure & balance. How can I get the
balance to auto fill using the other two columns?

Also want the total at the bottom of the sheet for each column, after
deductions have been made.

 

[Jason Morin]

Take a look at one of Microsoft's hundereds of templates
offered on-line (freely downloadable):

http://office.microsoft.com/en-
us/templates/CT010317261033.aspx

Look for "checkbook register".

HTH
Jason
Atlanta, GA

 

[Myrna Larson]

Assume you have headers in row 1, 1st row of data in row 2, income in A,
expenses in B (entered as a positive number), balance in C

In C2 use the formula

=A2-B2

IN C3 use the formula

=C2+A3-B3

and copy it down the rest of the column

Use SUM formulas to get the totals for each column.