Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract sum in one column from another
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract sum in one column from another
Formatting has nothing to do with this and there is no need to use SUM if
all you want is to subtract, you can copy down the formula by dragging the lower right corner with the mouse and copy it down and the formula as written will change =C3-B3 in the next cell it will change to =C4-B4 and so on -- Regards, Peo Sjoblom "bobby02169" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract sum in one column from another
"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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
subtract sum in one column from another
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 |
#5
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 |