Spreadsheet: 119807d1314760038-how-to-sum-data-sourced-through-indirect-and-match-prworkbook2
Sheet: AllDates

Name | Net Cons | CCY | Date
0 | 2360085.93 | AUD | 2011-08-01 00:00:00
0 | 35629.58 | BRL | 2011-08-01 00:00:00
0 | 135629865 | [NAME] | 2011-08-01 00:00:00
0 | 6016.5 | USD | 2011-08-01 00:00:00
0 | 6538 | CZK | 2011-08-01 00:00:00
0 | 126589.53 | CAD | 2011-08-01 00:00:00
1 | 542560 | AUD | 2011-08-30 00:00:00
2 | 180671 | AUD | 2011-08-30 00:00:00
3 | 116981 | AUD | 2011-08-30 00:00:00
4 | 480025 | BRL | 2011-08-30 00:00:00
5 | 300854 | BRL | 2011-08-30 00:00:00
6 | 211160 | BRL | 2011-08-30 00:00:00
7 | 674436 | HUF | 2011-08-30 00:00:00
8 | 251012 | HUF | 2011-08-30 00:00:00
9 | 212897 | HUF | 2011-08-30 00:00:00
10 | 218560 | HUF | 2011-08-30 00:00:00
11 | 87586 | DKK | 2011-08-30 00:00:00
12 | 392420 | DKK | 2011-08-30 00:00:00
13 | 128719 | DKK | 2011-08-30 00:00:00
14 | 382172 | DKK | 2011-08-30 00:00:00
15 | 1246735 | DKK | 2011-08-30 00:00:00
16 | 1397933 | DKK | 2011-08-30 00:00:00
17 | 1959879 | DKK | 2011-08-30 00:00:00
18 | 1164575 | DKK | 2011-08-30 00:00:00
19 | 1858946 | DKK | 2011-08-30 00:00:00
20 | 3141655 | AUD | 2011-08-30 00:00:00
21 | 1484487 | AUD | 2011-08-30 00:00:00
22 | 1321908 | AUD | 2011-08-30 00:00:00
23 | 1550474 | AUD | 2011-08-30 00:00:00
24 | 1167807 | AUD | 2011-08-30 00:00:00
25 | 896436 | AUD | 2011-08-30 00:00:00
26 | 496597 | AUD | 2011-08-30 00:00:00
27 | 290700 | AUD | 2011-08-30 00:00:00
28 | 1225900 | USD | 2011-08-30 00:00:00
29 | 561838 | GBP | 2011-08-30 00:00:00
30 | 611476 | GBP | 2011-08-30 00:00:00
31 | 644174 | GBP | 2011-08-30 00:00:00
32 | 541685 | GBP | 2011-08-30 00:00:00
33 | 548868 | USD | 2011-08-30 00:00:00
34 | 456083 | GBP | 2011-08-30 00:00:00
35 | 540984 | GBP | 2011-08-30 00:00:00
36 | 716847 | GBP | 2011-08-30 00:00:00
37 | 1306110 | USD | 2011-08-30 00:00:00
38 | 782784 | GBP | 2011-08-30 00:00:00
39 | 623832 | USD | 2011-08-30 00:00:00
40 | 670602 | GBP | 2011-08-30 00:00:00
41 | 517072 | GBP | 2011-08-30 00:00:00
42 | 558660 | GBP | 2011-08-30 00:00:00
1 | 542560.08 | AUD | 2011-08-31 00:00:00
2 | 180671.19 | AUD | 2011-08-31 00:00:00
3 | 116981.45 | AUD | 2011-08-31 00:00:00
4 | 480025.96 | BRL | 2011-08-31 00:00:00
5 | 300854.39 | BRL | 2011-08-31 00:00:00
6 | 211160.57 | BRL | 2011-08-31 00:00:00
7 | 674436.55 | HUF | 2011-08-31 00:00:00
8 | 251012.25 | HUF | 2011-08-31 00:00:00
9 | 212897.7 | HUF | 2011-08-31 00:00:00
10 | 218560.26 | HUF | 2011-08-31 00:00:00
11 | 87586.04 | DKK | 2011-08-31 00:00:00
12 | 392420.07 | DKK | 2011-08-31 00:00:00
13 | 128719.75 | DKK | 2011-08-31 00:00:00
14 | 382172.32 | DKK | 2011-08-31 00:00:00
15 | 1246735.56 | DKK | 2011-08-31 00:00:00
16 | 1397933.36 | DKK | 2011-08-31 00:00:00
17 | 1959879.17 | DKK | 2011-08-31 00:00:00
18 | 1164575.05 | DKK | 2011-08-31 00:00:00
19 | 1858946.94 | DKK | 2011-08-31 00:00:00
20 | 3141655.67 | AUD | 2011-08-31 00:00:00
21 | 1484487.94 | AUD | 2011-08-31 00:00:00
22 | 1321908.68 | AUD | 2011-08-31 00:00:00
23 | 1550474.84 | AUD | 2011-08-31 00:00:00
24 | 1167807.06 | AUD | 2011-08-31 00:00:00
25 | 896436.54 | AUD | 2011-08-31 00:00:00
26 | 496597.58 | AUD | 2011-08-31 00:00:00
27 | 290700.1 | AUD | 2011-08-31 00:00:00
28 | 1225900.12 | USD | 2011-08-31 00:00:00
29 | 561838.71 | GBP | 2011-08-31 00:00:00
30 | 611476.06 | GBP | 2011-08-31 00:00:00
31 | 644174.22 | GBP | 2011-08-31 00:00:00
32 | 541685.31 | GBP | 2011-08-31 00:00:00
33 | 548868.66 | USD | 2011-08-31 00:00:00
34 | 456083.83 | GBP | 2011-08-31 00:00:00
35 | 540984.73 | GBP | 2011-08-31 00:00:00
36 | 716847.39 | GBP | 2011-08-31 00:00:00
37 | 1306110.1 | USD | 2011-08-31 00:00:00
38 | 782784.02 | GBP | 2011-08-31 00:00:00
39 | 623832.91 | USD | 2011-08-31 00:00:00
40 | 670602.37 | GBP | 2011-08-31 00:00:00
41 | 517072.76 | GBP | 2011-08-31 00:00:00
42 | 558660.22 | GBP | 2011-08-31 00:00:00