# How to Calculate MPG in Excel – 5 Steps

The dataset below showcases a Milage Log of 10 days in May 2022.

Column B contains the Date, column C includes Odometer Readings, column D shows Distance Travelled (in Miles), and column E the Fuel Consumption (in Gallons).

The mathematical formula to calculate the MPG is:

`MPG = Total Distance Travelled / Total Fuel Consumed`

### Step 1 – Determine the Distance

• Subtract the odometer reading of the previous day from the odometer reading of the current day to get the mileage. Here, C11 is subtracted from C12:
`=C12-C11`

• Drag down the Fill Handle to see the result in the rest of the cells.

### Step 2 – Calculate the Daily MPG

• Select F11 and enter the formula below.
• Press ENTER.
`=D11/E11`

• Drag down the Fill Handle to see the result in the rest of the cells.

### Step 3 -Find the Total Distance and Total Fuel Consumption

• Select D16 and enter the formula below in the Formula Bar.
• Press ENTER.
`=SUM(D11:D15)`

The SUM function is used in D11:D15.

### Step  4 – Calculate the Average MPG

• Select D17 and use the formula below.
• Press ENTER.
`=D16/E16`

### Step 5 – Calculate the Average MPG Using the AVERAGE Function

An alternative to determine the Average MPG is to average the daily MPG values in F11:F15.

• Select F17, and enter the formula below.
• Press ENTER.
`=AVERAGE(F11:F15)`

The AVERAGE function calculates the Average MPG in F11:F15.

<< Go Back to Distance | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Shahriar Abrar Rafid

Shahriar Abrar Rafid, BSc, Naval Architecture and Marine Engineering, Bangladesh University of Engineering and Technology, Bangladesh, has worked with the ExcelDemy project for more than 1 year. He has written over 100+ articles for ExcelDemy. He is a professional visual content developer adept at crafting scripts, meticulously editing Excel files, and delivering insightful video tutorials for YouTube channels. His work and learning interests vary from Microsoft Office Suites and Excel to Data Analysis, VBA, and Video recording and... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF