How to get the yearly mileage and monthly avg from odometer only

Closed
jamishore
Posts
10
Registration date
Wednesday August 23, 2017
Status
Member
Last seen
September 13, 2017
- Sep 6, 2017 at 04:56 PM
How can I get excel to calculate the yearly mileage and monthly avg by just monthly odometer readings?

I Here is my worksheet:
https://www.dropbox.com/s/gs5dzetcrfeauvn/Average%20Miles.xlsx?dl=0