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.