Quote:
Originally Posted by TurnedTheCorner
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.
|
No, that won't give him a true average, because it assumes that he has driven exactly the same number of kms on each fill up.
MQS, just copy your formula that calculates the MPG in the first place, then replace the references to the cells to a reference to the sum of the whole column.
Either that, or create totals at the bottom of the litres filled up column, and the kms driven column, then just copy your calculation formulas that you already have to reference those totals.