Forum Discussion
Excel Miles driven using odemeter reading
I'm trying to set up a spreadsheet to track the miles driven and the average miles per gallon. I am not sure what formula to use to calculate the miles driven using the odometer readings.
The readings are
| 58828 | 59176 | 59478 | 59684 | 60006 | 60371 |
which should equal 1,543 miles driven but I'm getting -357543. I was told to use =SUM(-B7:V7)
I would love some help on this
If the first odometer reading is in B1 and the last one in V1, the number of miles driven is
=V1-B1
More generally, if the last reading isn't necessarily in V1, you can use
=MAX(1:1)-B1
