Spreadsheet: 129271d1321532527-index-match-formula-to-find-average-averagr-sums-2
Sheet: MPG

 | Drivers names | MPG-AVERAGE |  |  | helper columns(you can hide these)
 | [NAME] | 9.938253670341647 |  |  | 109.3207903737581 | 11
 | [NAME] | 7.338932737103225 |  |  | 88.06719284523871 | 12
 | [NAME] | 9.034711256943197 |  |  | 72.27769005554558 | 8
 | [NAME] | 8.58147092530638 |  |  | 94.39618017837019 | 11
 | Trevor | 9.358651514685047 |  |  | 93.58651514685046 | 10
Date | Driver Name | Total KMs Travelled | Total Miles Travelled | MPG
01.11.11 | [NAME] | 463 | 287.5776397515528 | 11.88479954827781 | [NAME]
01.11.11 | [NAME] | 24 | 14.90683229813665 | 3.986262331019364 | [NAME]
01.11.11 | [NAME] | 214 | 132.9192546583851 | 7.950670153644981 | [NAME]
01.11.11 | [NAME] | 578 | 359.0062111801242 | 9.89116506681724 | [NAME]
01.11.11 | Trevor | 220 | 136.6459627329193 | 10.01923462232018 | Trevor
01.11.11 | [NAME] | 196 | 121.7391304347826 | 9.223768115942027 | [NAME]
01.11.11 | [NAME] | 275 | 170.8074534161491 | 9.355309436503779 | [NAME]
01.11.11 | [NAME] | 403 | 250.3105590062112 | 8.88993594720497 | [NAME]
01.11.11 | [NAME] | 37 | 22.98136645962733 | 6.14548776032152 | [NAME]
01.11.11 | Trevor | 574 | 356.5217391304348 | 10.06675668376992 | Trevor
01.11.11 | [NAME] | 390 | 242.2360248447205 | 9.493146284000856 | [NAME]
01.11.11 | [NAME] | 381 | 236.6459627329192 | 9.779932241671371 | [NAME]
01.11.11 | [NAME] | 215 | 133.5403726708074 | 9.636103716849059 | [NAME]
01.11.11 | [NAME] | 573 | 355.9006211180124 | 9.406536183735376 | [NAME]
02.11.11 | Trevor | 504 | 313.0434782608696 | 10.16496894409938 | Trevor
02.11.11 | [NAME] | 108 | 67.0807453416149 | 8.470807453416148 | [NAME]
02.11.11 | [NAME] | 346 | 214.9068322981366 | 8.495360518498515 | [NAME]
02.11.11 | [NAME] | 384 | 238.5093167701863 | 9.511082052958484 | [NAME]
02.11.11 | [NAME] | 38 | 23.60248447204969 | 4.291875776397515 | [NAME]
02.11.11 | Trevor | 338 | 209.9378881987577 | 8.676160361377752 | Trevor
02.11.11 | [NAME] | 392 | 243.4782608695652 | 9.301278772378517 | [NAME]
02.11.11 | [NAME] | 381 | 236.6459627329192 | 8.675746343418153 | [NAME]
02.11.11 | [NAME] | 16 | 9.937888198757763 | 0
02.11.11 | [NAME] | 573 | 355.9006211180124 | 9.573516115991032 | [NAME]
02.11.11 | Trevor | 386 | 239.751552795031 | 9.73134427684117 | Trevor
02.11.11 | [NAME] | 38 | 23.60248447204969 | 0
02.11.11 | [NAME] | 410 | 254.6583850931677 | 11.02549541555753 | [NAME]
03.11.11 | [NAME] | 454 | 281.9875776397515 | 9.425849470222872 | [NAME]
03.11.11 | [NAME] | 355 | 220.4968944099379 | 9.546465542738835 | [NAME]
03.11.11 | Trevor | 196 | 121.7391304347826 | 7.379014492753623 | Trevor
03.11.11 | [NAME] | 468 | 290.6832298136646 | 12.01314511575381 | [NAME]
03.11.11 | [NAME] | 54 | 33.54037267080745 | 1.675544331444953 | [NAME]
03.11.11 | [NAME] | 212 | 131.6770186335404 | 0
03.11.11 | [NAME] | 397 | 246.583850931677 | 10.67590653652766 | [NAME]
03.11.11 | Trevor | 393 | 244.0993788819876 | 7.926255545696541 | Trevor
03.11.11 | [NAME] | 570 | 354.0372670807453 | 9.46737303617099 | [NAME]
03.11.11 | [NAME] | 389 | 241.6149068322981 | 4.224543717152413 | [NAME]
03.11.11 | [NAME] | 51 | 31.67701863354037 | 0
03.11.11 | [NAME] | 36 | 22.36024844720497 | 5.979393496529046 | [NAME]
03.11.11 | Trevor | 414 | 257.1428571428571 | 11.68971428571428 | Trevor
04.11.11 | [NAME] | 500 | 310.5590062111801 | 10.77710871935897 | [NAME]
04.11.11 | [NAME] | 393 | 244.0993788819876 | 9.247298136645963 | [NAME]
04.11.11 | [NAME] | 214 | 132.9192546583851 | 8.75725987937708 | [NAME]
04.11.11 | [NAME] | 341 | 211.8012422360248 | 8.915263400046008 | [NAME]
04.11.11 | Trevor | 69 | 42.85714285714285 | 0
04.11.11 | [NAME] | 417 | 259.0062111801242 | 9.419537888198757 | [NAME]
04.11.11 | [NAME] | 518 | 321.7391304347826 | 10.08707646176912 | [NAME]
04.11.11 | [NAME] | 406 | 252.1739130434783 | 9.245021037868163 | [NAME]
04.11.11 | [NAME] | 570 | 354.0372670807453 | 9.754263128176172 | [NAME]
04.11.11 | Trevor | 394 | 244.7204968944099 | 9.118847367885145 | Trevor
04.11.11 | [NAME] | 395 | 245.3416149068323 | 9.532675054414185 | [NAME]
04.11.11 | [NAME] | 48 | 29.81366459627329 | 1.426662307943773 | [NAME]
04.11.11 | [NAME] | 49 | 30.43478260869565 | 0
05.11.11 | [NAME] | 398 | 247.2049689440994 | 10.21630717108978 | [NAME]
05.11.11 | Trevor | 231 | 143.4782608695652 | 8.81421856639248 | Trevor
05.11.11 | [NAME] | 569 | 353.416149068323 | 9.73715038584604 | [NAME]
05.11.11 | [NAME] | 393 | 244.0993788819876 | 10.08796160361378 | [NAME]
05.11.11 | [NAME] | 204 | 126.7080745341615 | 8.86176779741997 | [NAME]