Spreadsheet: 274978d1383300690-how-to-get-range-sums-with-blank-line-in-the-data-965343
Sheet: Sheet1

Month | Vehicle | Card No. | Date | Supplier | Our Ref | Cust Ref | Odometer | Product | Litres | Nett
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-05-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-05-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-18 00:00:00 | [NAME] | 18388 |  |  | SURCHARGE |  | 8.8 |  | [NAME] | KMs Covered | Days | Litres | Expenditure |  | Latest Date | Position | Oldest Date | Position
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-18 00:00:00 | [NAME] | 18388 |  |  | DIESEL | 272.12 | 400.02 |  | [NAME]
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-14 00:00:00 | COLES EXPRESS KUNUNNURRA R/H | 3130 |  |  | DIESEL | 224.86 | 388.19 |  | BMG100
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-14 00:00:00 | [NAME] | 18272 |  |  | SURCHARGE |  | 8.46
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-14 00:00:00 | [NAME] | 18272 |  |  | DIESEL | 261.6 | 384.55
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-04 00:00:00 | UNITED NOONAMAH | 15226 |  |  | SURCHARGE |  | 7.34
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-04 00:00:00 | UNITED NOONAMAH | 15226 |  |  | DIESEL | 227.22 | 334.01
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-16 00:00:00 | UNITED KATHERINE | 10498 |  |  | SURCHARGE |  | 7.35
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-16 00:00:00 | UNITED KATHERINE | 10498 |  |  | DIESEL | 230.14 | 334.12
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-15 00:00:00 | HALLS CREEK TOYOTA | 5630 |  | 342305 | DIESEL | 278.6 | 448.3
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-14 00:00:00 | UNITED KATHERINE | 10468 |  |  | SURCHARGE |  | 5.91
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-14 00:00:00 | UNITED KATHERINE | 10468 |  |  | DIESEL | 184.87 | 268.4
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-08 00:00:00 | AFD DARWIN | 50768 |  | 347410 | ULS DIESEL (50) | 259.44 | 393.65
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-03-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-21 00:00:00 | ORD RIVER ROADHOUSE | 3619 |  |  | DIESEL | 227.12 | 396.22
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-20 00:00:00 | UNITED NOONAMAH | 14774 |  |  | DIESEL | 275.3 | 411.03
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-12 00:00:00 | UNITED COOLALINGA | 24177 |  |  | SURCHARGE |  | 9.72
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-12 00:00:00 | UNITED COOLALINGA | 24177 |  |  | DIESEL | 302.84 | 441.87
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-07 00:00:00 | BP TENNANT CREEK | 9359 |  |  | DIESEL | 282.93 | 438.55
2013-02-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-06 00:00:00 | AFD DARWIN | 49360 |  | 335412 | ULS DIESEL (50) | 311.78 | 464.55
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-02-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-01-30 00:00:00 | ORD RIVER ROADHOUSE | 2753 |  | 339748 | ULS DIESEL (50) | 233.74 | 403.54
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-01-29 00:00:00 | UNITED COOLALINGA | 23943 |  |  | SURCHARGE |  | 9.88
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-01-29 00:00:00 | UNITED COOLALINGA | 23943 |  |  | DIESEL | 307.98 | 449.37
2013-01-01 00:00:00 | [NAME] | 1797 0830 | 2013-01-09 00:00:00 | UNITED NOONAMAH | 14302 |  |  | DIESEL | 302.38 | 450.9
2012-10-01 00:00:00 | [NAME] | 1797 0830 | 2012-11-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2012-10-01 00:00:00 | [NAME] | 1797 0830 | 2012-11-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2012-10-01 00:00:00 | [NAME] | 1797 0830 | 2012-10-22 00:00:00 | UNITED NOONAMAH | 13399 |  |  | DIESEL | 283.5 | 428.54
2012-10-01 00:00:00 | [NAME] | 1797 0830 | 2012-10-04 00:00:00 | AFD DARWIN | 41949 |  | 325516 | ULS DIESEL (50) | 326.94 | 487.15
2012-09-01 00:00:00 | [NAME] | 1797 0830 | 2012-10-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2012-09-01 00:00:00 | [NAME] | 1797 0830 | 2012-10-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2012-09-01 00:00:00 | [NAME] | 1797 0830 | 2012-09-10 00:00:00 | AFD DARWIN | 40230 |  | 323485 | ULS DIESEL (50) | 322.65 | 477.82
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-09-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-09-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-08-28 00:00:00 | COLES EXPRESS KUNUNNURRA R/H | 4920 |  |  | DIESEL | 268.59 | 449.04
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-08-27 00:00:00 | BP BROOME CENTRAL | 9145 |  | 321246 | ULS DIESEL (50) | 190.23 | 292.09
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-08-24 00:00:00 | HALLS CREEK TOYOTA | 4882 |  | 320550 | DIESEL | 310 | 500
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-08-22 00:00:00 | AFD DARWIN | 39031 |  | 319193 | ULS DIESEL (50) | 321.69 | 464.71
2012-08-01 00:00:00 | [NAME] | 1797 0830 | 2012-08-09 00:00:00 | UNITED NOONAMAH | 12564 |  |  | DIESEL | 271.58 | 387.81
2013-04-01 00:00:00 | BMG100 | 2551 1030 | 2013-04-25 00:00:00 | COLES EXPRESS GOODNA | 7150 |  |  | AUTOGAS | 65.35 | 41.53
2013-04-01 00:00:00 | BMG100 | 2551 1030 | 2013-04-14 00:00:00 | UNITED SPRINGFIELD | 17574 |  |  | LPG | 67.65 | 45.69
2013-04-01 00:00:00 | BMG100 | 2551 1030 | 2013-04-04 00:00:00 | BP BLACKSOIL | 1449 |  | 20621 | AUTOGAS | 61.56 | 39.68
2013-03-01 00:00:00 | BMG100 | 2551 1030 | 2013-04-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-03-01 00:00:00 | BMG100 | 2551 1030 | 2013-04-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-03-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-28 00:00:00 | CALTEX WOOLWORTHS OXLEY | 529152 |  | 20150 | AUTOGAS | 77.16 | 49.04
2013-03-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-18 00:00:00 | CALTEX WOOLWORTHS OXLEY | 524655 |  | 19600 | AUTOGAS | 59.66 | 38.45
2013-03-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-07 00:00:00 | BP CONNECT COOMERA NORTH T/C | 336 |  | 18550 | AUTOGAS | 64.79 | 41.76
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-03-01 00:00:00 | BP CONNECT CABOOLTURE SOUTH T/C | 915 |  | 18000 | AUTOGAS | 70.84 | 45.02
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-28 00:00:00 | UNITED ROCKHAMPTON SOUTH | 2923 |  |  | LPG | 72.69 | 58.11
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-27 00:00:00 | CALTEX WOOLWORTHS OXLEY | 516364 |  | 16700 | AUTOGAS | 69.38 | 44.72
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-18 00:00:00 | BP CONNECT CABOOLTURE NORTH T/C | 6130 |  | 15600 | AUTOGAS | 41.22 | 26.95
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-18 00:00:00 | BP CONNECT CABOOLTURE SOUTH T/C | 15728 |  | 16200 | AUTOGAS | 62.93 | 41.14
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-14 00:00:00 | CALTEX WOOLWORTHS OXLEY | 510988 |  | 15320 | AUTOGAS | 66.32 | 42.75
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-11 00:00:00 | CALTEX WOOLWORTHS OXLEY | 509756 |  | 14755 | AUTOGAS | 37.1 | 23.92
2013-02-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-08 00:00:00 | CALTEX WOOLWORTHS OXLEY | 508755 |  | 14521 | AUTOGAS | 66.68 | 42.98
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-02-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-01-28 00:00:00 | UNITED SPRINGFIELD | 15927 |  |  | LPG | 58.66 | 43.44
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-01-23 00:00:00 | CALTEX WOOLWORTHS OXLEY | 503665 |  | 13350 | AUTOGAS | 69.84 | 45.02
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-01-16 00:00:00 | [NAME] | 551484 |  | 13170 | AUTOGAS | 67.52 | 45.36
2013-01-01 00:00:00 | BMG100 | 2551 1030 | 2013-01-10 00:00:00 | CALTEX WOOLWORTHS OXLEY | 498747 |  | 12700 | AUTOGAS | 67.38 | 43.43
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-11-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-11-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-31 00:00:00 | CALTEX WOOLWORTHS OXLEY | 502589 |  | 8288 | AUTOGAS | 69.97 | 47.65
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-20 00:00:00 | BP WACOL TRUCK STOP | 80407 |  | 7835 | AUTOGAS | 67.82 | 49.88
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-18 00:00:00 | UNITED GLADSTONE | 318676 |  |  | AUTOGAS | 59.29 | 44.2
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-17 00:00:00 | UNITED SPRINGFIELD | 13573 |  |  | LPG | 72.1 | 53.38
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-12 00:00:00 | BP CHARLTON | 35202 |  | 6100 | AUTOGAS | 56.64 | 39.6
2012-10-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-07 00:00:00 | UNITED SPRINGFIELD | 13306 |  |  | LPG | 48.17 | 33.87
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-10-02 00:00:00 | UNITED SPRINGFIELD | 13182 |  |  | LPG | 51.62 | 36.31
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-09-25 00:00:00 | TAJ ENTERPRISES | 7443 |  |  | LPG | 69.31 | 46.82
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-09-16 00:00:00 | UNITED SPRINGFIELD | 12827 |  |  | LPG | 69.7 | 45.14
2012-09-01 00:00:00 | BMG100 | 2551 1030 | 2012-09-05 00:00:00 | UNITED SPRINGFIELD | 12555 |  |  | LPG | 39.86 | 25.81