Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. . |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to increase maximum number of columns in excel 2003 | Excel Discussion (Misc queries) | |||
Columns in Excel will not allow user to click in them | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
interchange columns with rows | Excel Discussion (Misc queries) |