MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Mileage totals

Posted by Mike on June 26, 2001 6:50 PM

I know it's "an easy one" for most of the experts..
but I'm looking for a function code that will give the
"difference" or total. Example... in a range of cells,
say B1:B12 someone inputs mileage. How do I compute the
"total" number of miles traveled in B13?


Posted by Kevin James on June 26, 2001 9:52 PM

Mileage or odometer reading?

If it is traveled distance that is being entered in each cell, a simple =sum(range) will work.

If you are looking to enter odometer readings and find the difference for each day, use separate column to determine difference of each day and THEN run the SUM function.

This is not expert level stuff, this is math 101.