subtract amounts from different columns?
 

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.

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

-----Original Message-----
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.
.

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.

On Sat, 22 Jan 2005 07:59:03 -0800, "Paula"
wrote:

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.