| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
what formula to get total from two different columns
I have a worksheet that i want to use to keep track of my bank account i.e
money in and money out to give me a total in the third column and cannot work the formula out as 1 column is taking away and the secon column is adding????? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what formula to get total from two different columns
Post your formula.
-- Brevity is the soul of wit. "Mikeymike" wrote: I have a worksheet that i want to use to keep track of my bank account i.e money in and money out to give me a total in the third column and cannot work the formula out as 1 column is taking away and the secon column is adding????? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
what formula to get total from two different columns
If you want a running total the general philosophy is that in the total
column you need one additional cell. So if inflows are in A2:A10 and outflows are in B2:B10, put your starting balance in C1 and then in C2 use: =C1+A2-B2 Does this help? Kostis Vezerides Mikeymike wrote: I have a worksheet that i want to use to keep track of my bank account i.e money in and money out to give me a total in the third column and cannot work the formula out as 1 column is taking away and the secon column is adding????? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Pivot table for reporting sales performance | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula to total items from a drop list with values in several col | Excel Discussion (Misc queries) | |||
| keep a running total of my formula results after each (F9) | Excel Discussion (Misc queries) | |||
Linear Mode
