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

Date | Position | AUD | BRL | CAD | CHF | CZK | DKK | EUR | GBP | HKD | HUF | ILS | [NAME] | KRW | NOK | NZD | SEK | SGD | THB | TRY | USD | ZAR
30Aug2011 | Initial | 2360085.93 | 35629.58 | 126589.53 | 0 | 6538 | 0 | 0 | 0 | 0 | 0 | 0 | 135629865 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6016.5 | 0
 | Trade | 542560 | <- this cell should sum all of the AUD currency values sourced from sheet 30Aug2011
 | End | 2902645.93
31Aug2011 | Confirmation | (likely hardcoded reconcilation with another source)
 | Trade | sums relevant trades from 31Aug11 tab |  |  |  |  |  | Date | 2011-08-30 00:00:00 | <<You can filter by Date here
 | End | gives running end total
31Aug2011 | Initial | etc |  |  |  |  |  | Sum of Net Cons
 | Trade | etc |  |  |  |  |  | CCY | Total
 | End | etc |  |  |  |  |  | AUD | 11190281.13
 |  |  |  |  |  |  |  | BRL | 992040.9200000002
 |  |  |  |  |  |  |  | DKK | 8618968.26
 |  |  |  |  |  |  |  | GBP | 6602209.619999999
 |  |  |  |  |  |  |  | HUF | 1356906.76
 |  |  |  |  |  |  |  | USD | 3704711.790000001
 |  |  |  |  |  |  |  | Grand Total | 32465118.48
 |  |  |  |  |  |  |  |  |  | Data
 |  |  |  |  |  |  |  | CCY | Date | Sum of Net Cons | [NAME]
 |  |  |  |  |  |  |  | AUD | 2011-08-01 00:00:00 | 2360085.93 | 2360085.93
 |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 11190276 | 11190276
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 11190281.13 | 11190281.13
 |  |  |  |  |  |  |  | AUD Total |  | 24740643.06 | 24740643.06
 |  |  |  |  |  |  |  | BRL | 2011-08-01 00:00:00 | 35629.58 | 2395715.51
 |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 992039 | 12182315
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 992040.9200000002 | 12182322.05
 |  |  |  |  |  |  |  | BRL Total |  | 2019709.5 | 26760352.56
 |  |  |  |  |  |  |  | CAD | 2011-08-01 00:00:00 | 126589.53 | 2522305.04
 |  |  |  |  |  |  |  | CAD Total |  | 126589.53 | 26886942.09
 |  |  |  |  |  |  |  | CZK | 2011-08-01 00:00:00 | 6538 | 2528843.04
 |  |  |  |  |  |  |  | CZK Total |  | 6538 | 26893480.09
 |  |  |  |  |  |  |  | DKK | 2011-08-30 00:00:00 | 8618965 | 20801280
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 8618968.26 | 20801290.31
 |  |  |  |  |  |  |  | DKK Total |  | 17237933.26 | 44131413.34999999
 |  |  |  |  |  |  |  | GBP | 2011-08-30 00:00:00 | 6602205 | 27403485
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 6602209.619999999 | 27403499.93
 |  |  |  |  |  |  |  | GBP Total |  | 13204414.62 | 57335827.96999999
 |  |  |  |  |  |  |  | HUF | 2011-08-30 00:00:00 | 1356905 | 28760390
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 1356906.76 | 28760406.69
 |  |  |  |  |  |  |  | HUF Total |  | 2713811.76 | 60049639.72999999
 |  |  |  |  |  |  |  | [NAME] | 2011-08-01 00:00:00 | 135629865 | 138158708.04
 |  |  |  |  |  |  |  | JPY Total |  | 135629865 | 195679504.73
 |  |  |  |  |  |  |  | USD | 2011-08-01 00:00:00 | 6016.5 | 138164724.54
 |  |  |  |  |  |  |  |  | 2011-08-30 00:00:00 | 3704710 | 32465100
 |  |  |  |  |  |  |  |  | 2011-08-31 00:00:00 | 3704711.790000001 | 32465118.48
 |  |  |  |  |  |  |  | USD Total |  | 7415438.290000001 | 203094943.02
 |  |  |  |  |  |  |  | Grand Total |  | 203094943.02