Trying to keep track of the mileage on my car

**numbskull** · 09-02-2012, 01:40 PM

Hi Forum,

Every time I re-fuel my van I'm logging the mileage and trying to keep a running total of the miles traveled over a month

So, the first time i fuel the mileage is..34000
second time the mileage is................35600
third time the mileage is...................37000
forth time the mileage is......................?
fifth time the mileage is ......................?
six the mileage is................................?

running total of miles so far................3000 <---- could someone explain this formula please.

Many Thanks

**xladept** · 09-02-2012, 02:01 PM

What you've shown looks to be 300 gallons for 3000 miles i.e. the 300 looks to be the petrol used????

**numbskull** · 09-02-2012, 02:14 PM

Originally Posted by xladept

What you've shown looks to be 300 gallons for 3000 miles i.e. the 300 looks to be the petrol used????

Hi xladep, My mistake, I've edited the post and hope it makes more sense.

**jason.b75** · 09-02-2012, 07:30 PM

Looks like

=MAX(mileage range)-MIN(mileage range)

**xladept** · 09-02-2012, 08:10 PM

Hey numbskull,

Can you post the formula?

**numbskull** · 09-03-2012, 01:29 AM

Originally Posted by jason.b75

Looks like

=MAX(mileage range)-MIN(mileage range)

Nice one Jason, thanks

That works a treat

@ xladept, my formula =MAX(G36:G46)-MIN(G36:G46)

It takes the highest number entered and deducts the lowest