subtract sum in one column from another

[bobby02169]

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

 

[Peo Sjoblom]

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

 

[Mike H]

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

 

[Mike H]

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]

Thank you Mike and peo.
i meant to type formula not format.
Thanks
again