Spreadsheet: 727937d1618222574-how-to-sum-data-using-2-criteria-working-sum
Sheet: Balance

Benefit Code | Code | Bank Statement (as per currency)
51 | [NAME]
52 | 1350.52 | 68880.16
52 | 1400.CRAG
52 | 1495.MIN | 166666
53 | 1350.53 | 332347.9
53 | 1400.CRAG
53 | 1495.MIN | 166667
55 | 1308.55DV
55 | 1350.55 | 165428.27
55 | 1400.CRAG
55 | 1495.MIN | 166667
61 | 1300.61 | 257930.7799999999
61 | 1395.61M | 500000
62 | 1300.62 | 11608.12999999993
62 | 1395.62M | 500000
63 | 1300.63 | 253228.8
63 | 1350.63 | 873.58
63 | 1395.63 | 500000
64 | 1300.64 | 223791.6500000001
64 | 1380.T64 | 633.31
64 | 1395.64 | 500000
64 | 1400.CRAG
64 | 1400.WILM
79 | 1300.79 | 219304.89
79 | 1308.79DV
79 | 1395.79M | 500000
79 | 1400.CRAG
82 | 1300.82 C | 243009.25
82 | 1395.82MIN | 500000
82 | 1400.CRAG
82 | 1400.WILM
88 | 1300.88 | 266671.6300000001
88 | 1395.88 | 500000
88 | 1400.CRAG
88 | 1400.WILM
89 | 1300.89 | 267625.5299999998
89 | 1350.89 F | 2289.7
89 | 1395.89 | 500000
89 | 1400.CRAG
89 | 1400.WILM
98 | 1350.98 A | 9742.5
98 | 1420.GSL.DD.T98 | 140000
99 | 1300.99 | 120460.3400000004
99 | 1395.99MIN | 500000
99 | 1400.CRAG
99 | 1400.WILM
A2 | 1300.A2 | 268126.3500000001
A2 | 1395.A2MIN | 500000
A2 | 1400.CRAG
A2 | 1400.WILM
A6 | 1350.A6 | 10195.49000000011
A6 | 1420.GSL.DD.A6 | 140000
A7 | 1350.A7 | 23678.05999999998
A7 | 1420.GSL.DD.A7 | 120000
GSL ENTER | 1080.PETE
GSL ENTER | 1104.EFG $ GSL | 156.6600000000326
GSL ENTER | 1104.EFG EUR GSL | 126585.73
GSL ENTER | 1380.GSL ENT EUR | 71.71
GSL ENTER | 1380.GSL ENT USD | 436.6
GSL ENTER | 1520.GSL | 20117.88
GSL1 | 1351.ABN
GSL11 | 1351.ABN
GSL17 | 1351.ABN
GSL2 | 1351.ABN
GSL24 | 1350.GSL ABN Amro
GSL25 | 1350.GSL ABN Amro
GSLINC | 1106.UBS GSL Group | 4056.809999999851
GSLINC | 1300.GSL | 39351060.45
GSLINC | 1340.GSL [NAME] | 9385.53
GSLINC | 1350.GSL ABN Amro | 8560706.05
GSLINC | 1350.GSL UK | 259.34
GSLINC | 1450.Time Deposit | 25000000
GSLINC | 1450.UBS | 25000000
GSLINV | 1420.GSL ABN DD Reserve | 94527.23
GSLINV | 1450.GSL ABN | 506070.83
GSLLEG | 1350.GSL ABN Amro | 83.42
GSLS | 1350.GSL ABN Amro | 108529.67
GSLS | 1350.GSL UK | 115977.71
GSLS | 1350.GSLS Operating NL | 7888.08
KNA | 1350.GSL ABN Amro | 227.82
KNA | 1495.MIN | 7350000
O1 | 1315.O1 | 3258.25
O2 | 1315.O2 | 256.58
O3 | 1315.O3 | 1687207.11
O3 | 1415.O3R | 1678053.17
O3 | 1490.HFI | 1300000
O3 | 1495.MIN | 1830000
O4 | 1315.O4 | 1288586.02
O4 | 1415.O4R
O4 | 1490.HFI | 93333.31
O4 | 1495.MIN | 3592930.16
O5 | 1315.O5 | 3770115.67
O5 | 1415.O5R
O5 | 1490.HFI | 1300000.02
O5 | 1495.MIN | 1830000
P1 | 1106.UBS GSL Group | 1690272.26
P1 | 1300.P1 C | 1253432.16
P1 | 1350.P1 F | 2891.84
P1 | 1450.UBS | 3320000
P1 | 1490.HFI | 3300000
P4 | 1380.P4 | 1403.31
P6 | 1380.P6 | 198.51
P7 | 1380.P7 | 232.19
T148 | 1350.GSL ABN Amro | 5073.99
T148 | 1350.T148-GSL 52 | 653724.47
T148 | 1420.GSL.DD.T148 | 180000
T149 | 1350.T149-GSL 37 | 9009.160000000002
T150 | 1350.GSL ABN Amro
T150 | 1350.T150-GSL 43 | 766799.2000000002
T150 | 1420.GSL.DD.T150 | 180000
T151 | 1350.T151-GSL 39 | 738.4899999999998
T152 | 1350.T152-GSL 50 | 979394.76
T152 | 1420.GSL.DD.T152 | 700000
T153 | 1350.T153-GSL 51 | 891013.0900000003
T153 | 1420.GSL.DD.T153 | 760000
T154 | 1350.GSL ABN Amro | 6056.550000000001
T154 | 1350.T154-GSL 48 | 875374.8200000003
T154 | 1420.GSL.DD.T154 | 940000
T155 | 1350.GSL ABN Amro | 420370.87
T155 | 1390.GSL Hellenic €
T155 | 1420.GSL.DD.T155 | 280000
T156 | 1350.T156-GSL 54 | 905238.1499999997
T156 | 1420.GSL.DD.T156 | 400000
T157 | 1350.T157-GSL 44 | 8668.050000000017
T157 | 1420.GSL.DD.T157 | 480000
T158 | 1350.T158-GSL 47 | 265401.6400000001
T158 | 1351.ABN
T158 | 1420.GSL.DD.T158 | 280000
T159 | 1350.T159-GSL 49 | 855811.14
T159 | 1351.ABN
T159 | 1420.GSL.DD.T159 | 760000
T160 | 1350.T160-GSL 40 | 117258.96
T160 | 1351.ABN
T160 | 1420.GSL.DD.T160 | 260000
T161 | 1350.T161-GSL 45 | 127683.9999999999
T161 | 1351.ABN
T161 | 1420.GSL.DD.T161 | 480000
T162 | 1350.T162-GSL 41 | 339155.41
T162 | 1351.ABN
T162 | 1420.GSL.DD.T162 | 300000
T163 | 1350.T163-GSL 38 | 518273.5
T163 | 1351.ABN
T163 | 1420.GSL.DD.T163 | 600000
T164 | 1390.GSL Hellenic $ | 236209.54
T164 | 1400.Hellenic Ret | 519471.2
T164 | 1495.MIN | 300000
T165 | 1350.GSL ABN Amro | 6301.190000000001
T165 | 1350.T165-GSL 53 | 354889.25
T165 | 1351.ABN
T165 | 1420.GSL.DD.T165 | 120000
T166 | 1350.T166-GSL 46 | 8864.150000000081
T166 | 1351.ABN
T166 | 1420.GSL.DD.T166 | 1200000
T167 | 1350.GSL ABN Amro
T167 | 1350.T167-GSL 42 | 48895.53999999997
T167 | 1401.HAYFIN
T179 | 1390.GSL Hellenic $ | 164574.01
T179 | 1400.Hellenic Ret
T179 | 1495.MIN | 300000
T180 | 1390.GSL Hellenic $ | 165160.89
T180 | 1400.Hellenic Ret
T180 | 1495.MIN | 300000
T181 | 1390.GSL Hellenic $ | 234742.05
T181 | 1400.Hellenic Ret
T181 | 1495.MIN | 300000
T182 | 1390.GSL Hellenic $ | 282282.95
T182 | 1400.Hellenic Ret
T182 | 1495.MIN | 300000
T184 | 1350.GSL ABN Amro | 9354.01999999996
T184 | 1380.T184
T184 | 1420.GSL.DD.T184 | 260000
T185 | 1350.GSL ABN Amro | 6474.73000000004
T185 | 1380.T185
T185 | 1420.GSL.DD.T185 | 300000