| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding and subtraction
Hi, all i need to do is a value is added to column C adds to the running
totlal and if a value is put in column D it subtracts from the running total. Any help is appreciated Thanks Murray |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding and subtraction
Hi,
Put this anywhere except columns c or d =SUM(C:C)-SUM(D:D) or for a shorter range =SUM(C1:C100)-SUM(D1:D100) Mike "Murray" wrote: Hi, all i need to do is a value is added to column C adds to the running totlal and if a value is put in column D it subtracts from the running total. Any help is appreciated Thanks Murray |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Adding and subtraction
If your running total is on each row, (eg in column F), then you could
put this in F2: =F1+C2-D2 and copy down. Hope this helps. Pete On Oct 7, 11:27*am, Murray wrote: Hi, all i need to do is a value is added to column C adds to the running totlal and if a value is put in column D it subtracts from the running total. Any help is appreciated Thanks Murray |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple Adding/Subtraction and format of cell. - HELP!!! | Excel Worksheet Functions | |||
| Subtraction | Excel Worksheet Functions | |||
| Subtraction from a column. | Excel Discussion (Misc queries) | |||
| Please help with subtraction formula | New Users to Excel | |||
| subtraction formula | Excel Worksheet Functions | |||
Linear Mode
