Spreadsheet: 274915d1383259669-how-to-get-range-sums-with-blank-line-in-the-data-example_forum
Sheet: Example

Month | Vehicle | Card No. | Date | Supplier | Our Ref | Cust Ref | Odometer | Product | Litres | Nett |  | Task | Gather data only highlighted in yellow:
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-05-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92 |  | Details: | Odometer readings given randomly
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-05-03 00:00:00 |  |  |  |  | MANAGEMENT FEE |  | 3.35 |  |  | There could be instances where older dates would have higher odo readings (should be corrected if possible otherwise disregard)
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-18 00:00:00 | [NAME] | 18388 |  |  | SURCHARGE |  | 8.8
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-18 00:00:00 | [NAME] | 18388 |  |  | DIESEL | 272.12 | 400.02 |  | 1 | KMs covered between newest and latest odo readings
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 |  | 2 | Number of days between those readings
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-14 00:00:00 | [NAME] | 18272 |  |  | SURCHARGE |  | 8.46 |  | 3 | Total litres between those readings
2013-04-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-14 00:00:00 | [NAME] | 18272 |  |  | DIESEL | 261.6 | 384.55 |  | 4 | Total expenditure between those litres
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 |  | [NAME] | KMs Covered | Days | Litres | Expenditure
2013-03-01 00:00:00 | [NAME] | 1797 0830 | 2013-04-03 00:00:00 |  |  |  |  | CARD FEE ([NAME]) |  | 0.92 |  | [NAME]
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