| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract sum in one column from another
Thank you Mike and peo.
i meant to type formula not format. Thanks again "Mike H" wrote: Bobby, The correct formula is =c3-b3 you don't need the Sum bit. Enter you formula on the topmost cell and select that cell and all the cells you want to fill then:- Edit|Fill|Down If you already have data in columns C & B then enter the formula in the topmost cell and doubleclick the fill handle Mike "bobby02169" wrote: Hi All, I am trying to do a mileage worksheet, where I am putting in the staring mileage in column B and the ending in column C with the total milage driven in column D This is what I would like to do D=C-B. I can do it by formatting the cell in each row in column D =SUM(C3-B3), Can i format column D so the formula is automatically entered for each row? Thank you in advance bobby |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I subtract one column from another? | New Users to Excel | |||
| Column formulas to subtract value from value | Excel Discussion (Misc queries) | |||
| How do I add a column of cells, but IF a row has (), subtract? | Excel Worksheet Functions | |||
| HOW DO YOU ADD & SUBTRACT IN ONE COLUMN | Excel Worksheet Functions | |||
| subtract 10 from every number in a column | Excel Worksheet Functions | |||
Hybrid Mode
