View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bobby02169 bobby02169 is offline
external usenet poster
 
Posts: 24
Default 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