Do you want an average of all of the rates? i.e. Average MPG, KM/L and L/KM? Probably easiest to simply insert a formula at the end of each column, formula would be AVERAGE (Cell1:Cell10), or whatever range.
You can also simply highlight the range and right click in the bottom right of Excel to select 'Average', and simply manually check the average from time to time.
|