View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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