Spreadsheet: 818832d1677074315-a-sum-product-with-multiple-criteria-urgent-problem-test-34-_2
Sheet: Exercise 3

COST |  |  | Currency
Part | Cost |  | Part | Currency |  | EUR | GBP | USD |  |  |  |  |  |  | TOTAL COST |  |  |  |  | TOTAL COST
0102025 | 1.07 |  | 0121022 | EUR |  |  |  |  |  | Exchange | EUR | GBP | USD |  | Part | Description | Volume | Total Cost USD |  | Part | Description | Volume | Total Cost USD
0103541 | 32.54 |  | 0168972 | EUR |  |  |  |  |  | EUR | 1 | 0.84 | 1.16 |  | 48274 | S4080 11-13MM 7/16-1/2" | 23 |  |  | 48274 | S4080 11-13MM 7/16-1/2" | 23
0108038 | 49.24 |  | 0169374 | EUR |  |  |  |  |  | GBP |  | 1 | 1.38 |  | 0102016 | 404 3"BB 5/16-3/8" 2T | 335 |  |  | 0102016 | 404 3"BB 5/16-3/8" 2T | 335
0108065 | 352.47 |  | 0120096 | EUR |  |  |  |  |  | USD |  |  | 1 |  | 0102025 | 404 4-1/2"BB 3/8-1/2" 4T | 670 |  |  | 0102025 | 404 4-1/2"BB 3/8-1/2" 4T | 670
0108127 | 99.63 |  | 0109643 | EUR |  |  |  |  |  |  |  |  |  |  | 0103541 | 407 8"RB 1-1-1/8" 20T | 285 |  |  | 0103541 | 407 8"RB 1-1-1/8" 20T | 285
0108225 | 125.05 |  | 0109064 | EUR |  |  |  |  |  |  |  |  |  |  | 0108038 | 418   3"BB SBL 5/16-3/8" | 285 |  |  | 0108038 | 418   3"BB SBL 5/16-3/8" | 285
0108308 | 177.16 |  | 0121095 | EUR |  |  |  |  |  |  |  |  |  |  | 0108065 | 418 4-1/2"BB  3/8-1/2 4T | 35 |  |  | 0108065 | 418 4-1/2"BB  3/8-1/2 4T | 35
0108371 | 207.11 |  | 0121255 | EUR |  |  |  |  |  |  |  |  |  |  | 0108127 | 418   6"BB SN BL 5/8-3/4" | 168 |  |  | 0108127 | 418   6"BB SN BL 5/8-3/4" | 168
0108390 | 394.99 |  | 0108390 | EUR |  |  |  |  |  | Exchange |  |  |  |  | 0108225 | 418   8"BB SN BL 5/8-3/4" | 11 |  |  | 0108225 | 418   8"BB SN BL 5/8-3/4" | 11
0109037 | 334.33 |  | 0130655 | EUR |  |  |  |  |  | From | To | Rate |  |  | 0108308 | 421 8"BB 3/4-7/8" 15T | 47 |  |  | 0108308 | 421 8"BB 3/4-7/8" 15T | 47
0109064 | 436.81 |  | 0109607 | EUR |  |  |  |  |  | EUR | EUR | 1 |  |  | 0108371 | 420   10"BB SN BL 3/4-7/8 | 23 |  |  | 0108371 | 420   10"BB SN BL 3/4-7/8 | 23
0109091 | 59.19 |  | 0108065 | GBP |  |  |  |  |  | EUR | GBP | 0.84 |  |  | 0108390 | 421 10"BB 3/4-7/8" 15T | 23 |  |  | 0108390 | 421 10"BB 3/4-7/8" 15T | 23
0109126 | 108.5 |  | 0109420 | GBP |  |  |  |  |  | EUR | USD | 1.16 |  |  | 0109037 | 419 3"BB 5/16-3/8" 2T | 35 |  |  | 0109037 | 419 3"BB 5/16-3/8" 2T | 35
0109153 | 69.14 |  | 0297020 | GBP |  |  |  |  |  | GBP | EUR | 1.19 |  |  | 0109064 | 419 4-1/2"BB 3/8-1/2" 4T | 11 |  |  | 0109064 | 419 4-1/2"BB 3/8-1/2" 4T | 11
0109224 | 271.83 |  | 0109037 | GBP |  |  |  |  |  | GBP | GBP | 1 |  |  | 0109091 | 419 3"BB 5/16-3/8" 2T | 11 |  |  | 0109091 | 419 3"BB 5/16-3/8" 2T | 11
0109251 | 285.53 |  | 0109322 | GBP |  |  |  |  |  | GBP | USD | 1.38 |  |  | 0109126 | 419 6"BB 5/8-3/4" 8T | 47 |  |  | 0109126 | 419 6"BB 5/8-3/4" 8T | 47
0109322 | 318.88 |  | 0109527 | GBP |  |  |  |  |  | USD | EUR | 0.86 |  |  | 0109153 | 419 6"RB 5/8-3/4" 8T | 35 |  |  | 0109153 | 419 6"RB 5/8-3/4" 8T | 35
0109420 | 349.49 |  | 0297011 | GBP |  |  |  |  |  | USD | GBP | 0.73 |  |  | 0109224 | 419 8"BB 5/8-3/4" 8T | 11 |  |  | 0109224 | 419 8"BB 5/8-3/4" 8T | 11
0109527 | 293.36 |  | 0109251 | GBP |  |  |  |  |  | USD | USD | 1 |  |  | 0109251 | 419 8"RB 5/8-3/4" 8T | 0 |  |  | 0109251 | 419 8"RB 5/8-3/4" 8T | 0
0109607 | 373.93 |  | 0109224 | GBP |  |  |  |  |  |  |  |  |  |  | 0109322 | 419 10"BB 5/8-3/4" 8T | 70 |  |  | 0109322 | 419 10"BB 5/8-3/4" 8T | 70
0109643 | 613.08 |  | 0108371 | GBP |  |  |  |  |  |  |  |  |  |  | 0109420 | 419 12"BB 3/4" 8T | 0 |  |  | 0109420 | 419 12"BB 3/4" 8T | 0
0120096 | 758.56 |  | 0108308 | GBP |  |  |  |  |  |  |  |  |  |  | 0109527 | 419 14"BB 5/8-3/4" 8T | 11 |  |  | 0109527 | 419 14"BB 5/8-3/4" 8T | 11
0121022 | 979.72 |  | 0108225 | GBP |  |  |  |  |  |  |  |  |  |  | 0109607 | 419 16"BB 3/4-7/8" 15T | 23 |  |  | 0109607 | 419 16"BB 3/4-7/8" 15T | 23
0121095 | 397.58 |  | 0109126 | USD |  |  |  |  |  |  |  |  |  |  | 0109643 | 419 18"BB 1" 15T | 0 |  |  | 0109643 | 419 18"BB 1" 15T | 0
0121255 | 397.24 |  | 0108127 | USD |  |  |  |  |  |  |  |  |  |  | 0120096 | 430   10"BB SN BL 1-1.1/8 | 0 |  |  | 0120096 | 430   10"BB SN BL 1-1.1/8 | 0
0130655 | 391.68 |  | 0109153 | USD |  |  |  |  |  |  |  |  |  |  | 0121022 | 431 8"BB 1-1-1/8" 20T | 35 |  |  | 0121022 | 431 8"BB 1-1-1/8" 20T | 35
0168972 | 863.06 |  | 0109091 | USD |  |  |  |  |  |  |  |  |  |  | 0121095 | 431 10"BB 1-1-1/8" 20T | 23 |  |  | 0121095 | 431 10"BB 1-1-1/8" 20T | 23
0169374 | 833.95 |  | 0108038 | USD |  |  |  |  |  |  |  |  |  |  | 0121255 | 431 14"BB 1-1/8" 20T | 59 |  |  | 0121255 | 431 14"BB 1-1/8" 20T | 59
0297011 | 289.76 |  | 0103541 | USD |  |  |  |  |  |  |  |  |  |  | 0130655 | [NAME]" 9T | 47 |  |  | 0130655 | [NAME]" 9T | 47
0297020 | 342.71 |  | 0102025 | USD |  |  |  |  |  |  |  |  |  |  | 0168972 | 417 6"BB 3/4-7/8" 12T | 35 |  |  | 0168972 | 417 6"BB 3/4-7/8" 12T | 35
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0169374 | 420   6" BB SN BL 3/4-7/8 | 298 |  |  | 0169374 | 420   6" BB SN BL 3/4-7/8 | 298