Spreadsheet: 154336d1336391034-need-help-on-summing-between-dates-0test-9-
Sheet: ALL SALES

 |  |  |  |  |  |  |  |  | 1
 | Inv Date |  |  |  |  |  | TOTAL
 | 2012-01-03 00:00:00 | 689.9 | 689.9 | GBP | 1 |  | 689.9
 | 2012-01-03 00:00:00 | 8850.35 | 8850.35 | EUR | 1.19 |  | 7437.268907563026
 | 2012-01-03 00:00:00 | 293.25 | 293.25 | GBP | 1 |  | 293.25
 | 2012-01-03 00:00:00 | 1030.32 | 1236.38 | GBP | 1 |  | 1030.32
 | 2012-01-03 00:00:00 | 2547.45 | 2547.45 | GBP | 1 |  | 2547.45
 | 2012-01-03 00:00:00 | 1214.79 | 1214.79 | USD | 1.55 |  | 783.7354838709676
 | 2012-01-03 00:00:00 | 441.78 | 441.78 | EUR | 1.19 |  | 371.2436974789916
 | 2012-01-03 00:00:00 | 701.49 | 841.79 | GBP | 1 |  | 701.49
 | 2012-01-03 00:00:00 | 2597.48 | 3116.98 | GBP | 1 |  | 2597.48
 | 2012-01-03 00:00:00 | 362.31 | 362.31 | USD | 1.55 |  | 233.7483870967742
 | 2012-01-03 00:00:00 | 1209.67 | 1209.67 | EUR | 1.19 |  | 1016.529411764706
 | 2012-01-03 00:00:00 | 388.75 | 388.75 | GBP | 1 |  | 388.75
 | 2012-01-03 00:00:00 | 302.5 | 302.5 | GBP | 1 |  | 302.5
 | 2012-01-03 00:00:00 | 440 | 440 | GBP | 1 |  | 440
 | 2012-01-03 00:00:00 | 441.78 | 441.78 | EUR | 1.19 |  | 371.2436974789916
 | 2012-01-03 00:00:00 | 165 | 198 | GBP | 1 |  | 165
 | 2012-01-03 00:00:00 | 233.75 | 233.75 | GBP | 1 |  | 233.75
 | 2012-01-03 00:00:00 | 589.03 | 589.03 | EUR | 1.19 |  | 494.9831932773109
 | 2012-01-04 00:00:00 | 2013.07 | 2013.07 | EUR | 1.2 |  | 1677.558333333333
 | 2012-01-04 00:00:00 | 234.5 | 281.4 | GBP | 1 |  | 234.5
 | 2012-01-04 00:00:00 | 327.25 | 392.7 | GBP | 1 |  | 327.25
 | 2012-01-04 00:00:00 | 5837.84 | 5837.84 | EUR | 1.2 |  | 4864.866666666667
 | 2012-01-04 00:00:00 | 796.43 | 796.43 | EUR | 1.2 |  | 663.6916666666666
 | 2012-01-04 00:00:00 | 1665.64 | 1998.77 | GBP | 1 |  | 1665.64
 | 2012-01-05 00:00:00 | 210.71 | 252.85 | GBP | 1 |  | 210.71
 | 2012-01-10 00:00:00 | 1524.04 | 1524.04 | GBP | 1 |  | 1524.04
 | 2012-01-17 00:00:00 | -107.25 | -107.25 | USD | 1.56 |  | -68.75
 | 2012-01-17 00:00:00 | 6553.33 | 6553.33 | EUR | 1.2 |  | 5461.108333333334
 | 2012-01-17 00:00:00 |  |  | EUR
 | 2012-01-17 00:00:00 |  |  | EUR
 | 2012-01-17 00:00:00 | 106925 | 128310 | GBP | 1 |  | 106925
 | 2012-01-19 00:00:00 | 1400 | 1400 | GBP | 1 |  | 1400
 | 2012-01-19 00:00:00 | 700 | 840 | GBP | 1 |  | 700
 | 2012-01-19 00:00:00 | 150 | 150 | GBP | 1 |  | 150
 | 2012-01-19 00:00:00 | 225 | 270 | GBP | 1 |  | 225
 | 2012-01-25 00:00:00 | 75 | 90 | GBP | 1 |  | 75
 | 2012-01-26 00:00:00 | 950 | 950 | GBP | 1 |  | 950
 | 2012-01-26 00:00:00 | 75 | 90 | GBP | 1 |  | 75
 | 2012-01-26 00:00:00 | 400 | 480 | GBP | 1 |  | 400
 | 2012-01-26 00:00:00 | 150 | 150 | GBP | 1 |  | 150
 | 2012-01-26 00:00:00 | 150 | 150 | GBP | 1 |  | 150
 | 2012-01-26 00:00:00 | 157.55 | 189.06 | GBP | 1 |  | 157.55
 | 2012-01-26 00:00:00
 | 2012-01-26 00:00:00
 | 2012-01-27 00:00:00 | -165 | -165 | EUR | 1.2 |  | -137.5
 | 2012-01-27 00:00:00 | -68.75 | -82.5 | GBP | 1 |  | -68.75
 | 2012-01-27 00:00:00 | -119.62 | -119.62 | EUR | 1.16 |  | -103.1206896551724
 | 2012-01-27 00:00:00 | -565 | -565 | GBP | 1 |  | -565
 | 2012-01-27 00:00:00 | -735.7 | -735.7 | EUR | 1.17 |  | -628.8034188034189
 | 2012-01-30 00:00:00 | 986.67 | 986.67 | GBP | 1 |  | 986.67
 | 2012-01-31 00:00:00 | -233.75 | -233.75 | GBP | 1 |  | -233.75
 | 2012-01-31 00:00:00 | 58.41 | 58.41 | GBP | 1 |  | 58.41
 | 2012-01-31 00:00:00 | -441.78 | -441.78 | EUR | 1.19 |  | -371.2436974789916
 | 2012-01-31 00:00:00 | 110.37 | 110.37 | EUR | 1.19 |  | 92.74789915966387
 | 2012-01-31 00:00:00 | 75 | 90 | GBP | 1 |  | 75
 | 2012-01-31 00:00:00 | 75 | 90 | GBP | 1 |  | 75
 | 2012-01-31 00:00:00 | 1200 | 1200 | GBP | 1 |  | 1200
 | 2012-01-31 00:00:00 | 463.13 | 463.13 | GBP | 1 |  | 463.13
 | 2012-02-07 00:00:00 | -42699.46 | -42699.46 | GBP | 1 |  | -42699.46
 | 2012-02-07 00:00:00 | 41316.09 | 41316.09 | GBP | 1 |  | 41316.09
 | 2012-02-07 00:00:00 | 1500 | 1800 | GBP | 1 |  | 1500
 | 2012-02-07 00:00:00 | 1500 | 1800 | GBP | 1 |  | 1500
 | 2012-02-07 00:00:00 | 1105 | 1105 | EUR | 1.17 |  | 944.4444444444445
 | 2012-02-08 00:00:00 | 75 | 75 | GBP | 1 |  | 75
 | 2012-02-08 00:00:00 | 240 | 240 | EUR | 1.2 |  | 200
 | 2012-02-08 00:00:00 | 2045.52 | 2045.52 | EUR | 1.16 |  | 1763.379310344828
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00 | 1752.67 | 1752.67 | GBP | 1 |  | 1752.67
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00
 | 2012-02-13 00:00:00 | 3027 | 3027 | USD | 1.57 |  | 1928.025477707006
 | 2012-02-13 00:00:00 | 980 | 980 | USD | 1.57 |  | 624.2038216560509
 | 2012-02-13 00:00:00 | 1742 | 1742 | USD | 1.57 |  | 1109.554140127389
 | 2012-02-13 00:00:00 | 980 | 980 | EUR | 1.19 |  | 823.529411764706
 | 2012-02-13 00:00:00 | 1220 | 1220 | USD | 1.57 |  | 777.0700636942674
 | 2012-02-13 00:00:00 | 1220 | 1220 | USD | 1.57 |  | 777.0700636942674
 | 2012-02-13 00:00:00 | 5616 | 5616 | USD | 1.57 |  | 3577.070063694267
 | 2012-02-13 00:00:00 | 1340 | 1340 | USD | 1.57 |  | 853.5031847133757
 | 2012-02-13 00:00:00 | 1915 | 1915 | USD | 1.57 |  | 1219.745222929936
 | 2012-02-13 00:00:00 | 1290 | 1290 | USD | 1.57 |  | 821.656050955414
 | 2012-02-13 00:00:00 | 2018.25 | 2018.25 | USD | 1.57 |  | 1285.509554140127
 | 2012-02-13 00:00:00 | 1680 | 1680 | USD | 1.57 |  | 1070.063694267516
 | 2012-02-13 00:00:00 | 6230 | 6230 | USD | 1.57 |  | 3968.152866242038
 | 2012-02-13 00:00:00 | 1080 | 1080 | EUR | 1.19 |  | 907.5630252100841
 | 2012-02-13 00:00:00 | 1920 | 1920 | USD | 1.57 |  | 1222.929936305732
 | 2012-02-13 00:00:00 | 1719 | 1719 | USD | 1.57 |  | 1094.904458598726
 | 2012-02-13 00:00:00 | 1910 | 1910 | USD | 1.57 |  | 1216.56050955414
 | 2012-02-13 00:00:00 | 6376 | 6376 | USD | 1.57 |  | 4061.146496815286
 | 2012-02-13 00:00:00 | 500 | 500 | USD | 1.57 |  | 318.4713375796178
 | 2012-02-15 00:00:00 | 718.15 | 718.15 | USD | 1.57 |  | 457.4203821656051
 | 2012-02-15 00:00:00 | 440 | 440 | GBP | 1 |  | 440
 | 2012-02-15 00:00:00 | 302.5 | 363 | GBP | 1 |  | 302.5
 | 2012-02-15 00:00:00 | 760 | 912 | GBP | 1 |  | 760
 | 2012-02-15 00:00:00 | 278.16 | 278.16 | EUR | 1.19 |  | 233.7478991596639
 | 2012-02-15 00:00:00 | 521.75 | 521.75 | USD | 1.57 |  | 332.3248407643312
 | 2012-02-15 00:00:00 | 233.75 | 280.5 | GBP | 1 |  | 233.75
 | 2012-02-15 00:00:00 | 451.59 | 451.59 | EUR | 1.19 |  | 379.4873949579832
 | 2012-02-15 00:00:00 | 2150 | 2150 | USD | 1.57 |  | 1369.426751592357
 | 2012-02-15 00:00:00 | 465.75 | 558.9 | GBP | 1 |  | 465.75
 | 2012-02-15 00:00:00 | 526.25 | 631.5 | GBP | 1 |  | 526.25
 | 2012-02-15 00:00:00 | 302.5 | 302.5 | GBP | 1 |  | 302.5
 | 2012-02-15 00:00:00 | 2470 | 2470 | USD | 1.57 |  | 1573.248407643312
 | 2012-02-16 00:00:00 | 633.75 | 633.75 | USD | 1.56 |  | 406.25
 | 2012-02-16 00:00:00 | 2350 | 2350 | GBP | 1 |  | 2350
 | 2012-02-16 00:00:00 | 203.62 | 203.62 | EUR | 1.2 |  | 169.6833333333333
 | 2012-02-16 00:00:00 | 570.37 | 684.44 | GBP | 1 |  | 570.37
 | 2012-02-16 00:00:00 | 638.25 | 765.9 | GBP | 1 |  | 638.25
 | 2012-02-16 00:00:00 | 5194.9 | 6233.88 | GBP | 1 |  | 5194.9
 | 2012-02-16 00:00:00 | 7861.17 | 9433.4 | GBP | 1 |  | 7861.17
 | 2012-02-16 00:00:00 | 1575.34 | 1890.41 | GBP | 1 |  | 1575.34
 | 2012-02-16 00:00:00 | 1256.6 | 1507.92 | GBP | 1 |  | 1256.6
 | 2012-02-16 00:00:00 | 2617.72 | 2617.72 | EUR | 1.2 |  | 2181.433333333333
 | 2012-02-16 00:00:00 | 392.7 | 392.7 | EUR | 1.2 |  | 327.25
 | 2012-02-16 00:00:00 | 1365.21 | 1638.25 | GBP | 1 |  | 1365.21
 | 2012-02-16 00:00:00 | 1730.71 | 1730.71 | USD | 1.56 |  | 1109.429487179487
 | 2012-02-16 00:00:00 | 2010.23 | 2010.23 | GBP | 1 |  | 2010.23
 | 2012-02-16 00:00:00 | -2700 | -3240 | GBP | 1 |  | -2700
 | 2012-02-16 00:00:00 | 2200 | 2640 | GBP | 1 |  | 2200
 | 2012-02-16 00:00:00 | 1280 | 1536 | GBP | 1 |  | 1280
 | 2012-02-20 00:00:00 | 10002.17 | 12002.6 | GBP | 1 |  | 10002.17
 |  |  |  |  | 1 |  | 0