Spreadsheet: 154331d1336387204-need-help-on-summing-between-dates-test
Sheet: ALL SALES

 | Inv Date |  |  |  |  |  | TOTAL
 | 2012-01-03 00:00:00 | 689.9 | 689.9 | GBP | 1
 | 2012-01-03 00:00:00 | 8850.35 | 8850.35 | EUR | 1.19
 | 2012-01-03 00:00:00 | 293.25 | 293.25 | GBP | 1
 | 2012-01-03 00:00:00 | 1030.32 | 1236.38 | GBP | 1
 | 2012-01-03 00:00:00 | 2547.45 | 2547.45 | GBP | 1
 | 2012-01-03 00:00:00 | 1214.79 | 1214.79 | USD | 1.55
 | 2012-01-03 00:00:00 | 441.78 | 441.78 | EUR | 1.19
 | 2012-01-03 00:00:00 | 701.49 | 841.79 | GBP | 1
 | 2012-01-03 00:00:00 | 2597.48 | 3116.98 | GBP | 1
 | 2012-01-03 00:00:00 | 362.31 | 362.31 | USD | 1.55
 | 2012-01-03 00:00:00 | 1209.67 | 1209.67 | EUR | 1.19
 | 2012-01-03 00:00:00 | 388.75 | 388.75 | GBP | 1
 | 2012-01-03 00:00:00 | 302.5 | 302.5 | GBP | 1
 | 2012-01-03 00:00:00 | 440 | 440 | GBP | 1
 | 2012-01-03 00:00:00 | 441.78 | 441.78 | EUR | 1.19
 | 2012-01-03 00:00:00 | 165 | 198 | GBP | 1
 | 2012-01-03 00:00:00 | 233.75 | 233.75 | GBP | 1
 | 2012-01-03 00:00:00 | 589.03 | 589.03 | EUR | 1.19
 | 2012-01-04 00:00:00 | 2013.07 | 2013.07 | EUR | 1.2
 | 2012-01-04 00:00:00 | 234.5 | 281.4 | GBP | 1
 | 2012-01-04 00:00:00 | 327.25 | 392.7 | GBP | 1
 | 2012-01-04 00:00:00 | 5837.84 | 5837.84 | EUR | 1.2
 | 2012-01-04 00:00:00 | 796.43 | 796.43 | EUR | 1.2
 | 2012-01-04 00:00:00 | 1665.64 | 1998.77 | GBP | 1
 | 2012-01-05 00:00:00 | 210.71 | 252.85 | GBP | 1
 | 2012-01-10 00:00:00 | 1524.04 | 1524.04 | GBP | 1
 | 2012-01-17 00:00:00 | -107.25 | -107.25 | USD | 1.56
 | 2012-01-17 00:00:00 | 6553.33 | 6553.33 | EUR | 1.2
 | 2012-01-17 00:00:00 |  |  | EUR
 | 2012-01-17 00:00:00 |  |  | EUR
 | 2012-01-17 00:00:00 | 106925 | 128310 | GBP | 1
 | 2012-01-19 00:00:00 | 1400 | 1400 | GBP | 1
 | 2012-01-19 00:00:00 | 700 | 840 | GBP | 1
 | 2012-01-19 00:00:00 | 150 | 150 | GBP | 1
 | 2012-01-19 00:00:00 | 225 | 270 | GBP | 1
 | 2012-01-25 00:00:00 | 75 | 90 | GBP | 1
 | 2012-01-26 00:00:00 | 950 | 950 | GBP | 1
 | 2012-01-26 00:00:00 | 75 | 90 | GBP | 1
 | 2012-01-26 00:00:00 | 400 | 480 | GBP | 1
 | 2012-01-26 00:00:00 | 150 | 150 | GBP | 1
 | 2012-01-26 00:00:00 | 150 | 150 | GBP | 1
 | 2012-01-26 00:00:00 | 157.55 | 189.06 | GBP | 1
 | 2012-01-26 00:00:00
 | 2012-01-26 00:00:00
 | 2012-01-27 00:00:00 | -165 | -165 | EUR | 1.2
 | 2012-01-27 00:00:00 | -68.75 | -82.5 | GBP | 1
 | 2012-01-27 00:00:00 | -119.62 | -119.62 | EUR | 1.16
 | 2012-01-27 00:00:00 | -565 | -565 | GBP | 1
 | 2012-01-27 00:00:00 | -735.7 | -735.7 | EUR | 1.17
 | 2012-01-30 00:00:00 | 986.67 | 986.67 | GBP | 1
 | 2012-01-31 00:00:00 | -233.75 | -233.75 | GBP | 1
 | 2012-01-31 00:00:00 | 58.41 | 58.41 | GBP | 1
 | 2012-01-31 00:00:00 | -441.78 | -441.78 | EUR | 1.19
 | 2012-01-31 00:00:00 | 110.37 | 110.37 | EUR | 1.19
 | 2012-01-31 00:00:00 | 75 | 90 | GBP | 1
 | 2012-01-31 00:00:00 | 75 | 90 | GBP | 1
 | 2012-01-31 00:00:00 | 1200 | 1200 | GBP | 1
 | 2012-01-31 00:00:00 | 463.13 | 463.13 | GBP | 1
 | 2012-02-07 00:00:00 | -42699.46 | -42699.46 | GBP | 1
 | 2012-02-07 00:00:00 | 41316.09 | 41316.09 | GBP | 1
 | 2012-02-07 00:00:00 | 1500 | 1800 | GBP | 1
 | 2012-02-07 00:00:00 | 1500 | 1800 | GBP | 1
 | 2012-02-07 00:00:00 | 1105 | 1105 | EUR | 1.17
 | 2012-02-08 00:00:00 | 75 | 75 | GBP | 1
 | 2012-02-08 00:00:00 | 240 | 240 | EUR | 1.2
 | 2012-02-08 00:00:00 | 2045.52 | 2045.52 | EUR | 1.16
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00 | 1752.67 | 1752.67 | GBP | 1
 | 2012-02-08 00:00:00
 | 2012-02-08 00:00:00
 | 2012-02-13 00:00:00 | 3027 | 3027 | USD | 1.57
 | 2012-02-13 00:00:00 | 980 | 980 | USD | 1.57
 | 2012-02-13 00:00:00 | 1742 | 1742 | USD | 1.57
 | 2012-02-13 00:00:00 | 980 | 980 | EUR | 1.19
 | 2012-02-13 00:00:00 | 1220 | 1220 | USD | 1.57
 | 2012-02-13 00:00:00 | 1220 | 1220 | USD | 1.57
 | 2012-02-13 00:00:00 | 5616 | 5616 | USD | 1.57
 | 2012-02-13 00:00:00 | 1340 | 1340 | USD | 1.57
 | 2012-02-13 00:00:00 | 1915 | 1915 | USD | 1.57
 | 2012-02-13 00:00:00 | 1290 | 1290 | USD | 1.57
 | 2012-02-13 00:00:00 | 2018.25 | 2018.25 | USD | 1.57
 | 2012-02-13 00:00:00 | 1680 | 1680 | USD | 1.57
 | 2012-02-13 00:00:00 | 6230 | 6230 | USD | 1.57
 | 2012-02-13 00:00:00 | 1080 | 1080 | EUR | 1.19
 | 2012-02-13 00:00:00 | 1920 | 1920 | USD | 1.57
 | 2012-02-13 00:00:00 | 1719 | 1719 | USD | 1.57
 | 2012-02-13 00:00:00 | 1910 | 1910 | USD | 1.57
 | 2012-02-13 00:00:00 | 6376 | 6376 | USD | 1.57
 | 2012-02-13 00:00:00 | 500 | 500 | USD | 1.57
 | 2012-02-15 00:00:00 | 718.15 | 718.15 | USD | 1.57
 | 2012-02-15 00:00:00 | 440 | 440 | GBP | 1
 | 2012-02-15 00:00:00 | 302.5 | 363 | GBP | 1
 | 2012-02-15 00:00:00 | 760 | 912 | GBP | 1
 | 2012-02-15 00:00:00 | 278.16 | 278.16 | EUR | 1.19
 | 2012-02-15 00:00:00 | 521.75 | 521.75 | USD | 1.57
 | 2012-02-15 00:00:00 | 233.75 | 280.5 | GBP | 1
 | 2012-02-15 00:00:00 | 451.59 | 451.59 | EUR | 1.19
 | 2012-02-15 00:00:00 | 2150 | 2150 | USD | 1.57
 | 2012-02-15 00:00:00 | 465.75 | 558.9 | GBP | 1
 | 2012-02-15 00:00:00 | 526.25 | 631.5 | GBP | 1
 | 2012-02-15 00:00:00 | 302.5 | 302.5 | GBP | 1
 | 2012-02-15 00:00:00 | 2470 | 2470 | USD | 1.57
 | 2012-02-16 00:00:00 | 633.75 | 633.75 | USD | 1.56
 | 2012-02-16 00:00:00 | 2350 | 2350 | GBP | 1
 | 2012-02-16 00:00:00 | 203.62 | 203.62 | EUR | 1.2
 | 2012-02-16 00:00:00 | 570.37 | 684.44 | GBP | 1
 | 2012-02-16 00:00:00 | 638.25 | 765.9 | GBP | 1
 | 2012-02-16 00:00:00 | 5194.9 | 6233.88 | GBP | 1
 | 2012-02-16 00:00:00 | 7861.17 | 9433.4 | GBP | 1
 | 2012-02-16 00:00:00 | 1575.34 | 1890.41 | GBP | 1
 | 2012-02-16 00:00:00 | 1256.6 | 1507.92 | GBP | 1
 | 2012-02-16 00:00:00 | 2617.72 | 2617.72 | EUR | 1.2
 | 2012-02-16 00:00:00 | 392.7 | 392.7 | EUR | 1.2
 | 2012-02-16 00:00:00 | 1365.21 | 1638.25 | GBP | 1
 | 2012-02-16 00:00:00 | 1730.71 | 1730.71 | USD | 1.56
 | 2012-02-16 00:00:00 | 2010.23 | 2010.23 | GBP | 1
 | 2012-02-16 00:00:00 | -2700 | -3240 | GBP | 1
 | 2012-02-16 00:00:00 | 2200 | 2640 | GBP | 1
 | 2012-02-16 00:00:00 | 1280 | 1536 | GBP | 1
 | 2012-02-20 00:00:00 | 10002.17 | 12002.6 | GBP | 1