Spreadsheet: 763574d1642253800-sum-different-currencies-and-convert-them-all-sheet-by-glenn-kennedy
Sheet: Exp

 | P.Code | P.Name | Supplier | Status | Currency | Subtotal | Milestone |  |  | Exhange Rate
 |  |  | - | - | - | - | - | Exchange Rate | After Exchange | EUR (€) | 4.05
 | Project #01 |  | Supplier #01 | Paid | EUR (€) | 2250 | 100% Payment |  |  | GBP (£) | 4.4
 | Project #01 |  | Supplier #02 | Submitted | SAR | 0 | 100% Payment |  |  | USD ($) | 3.75
 | Project #01 |  | Supplier #03 | Paid | AED | 509.48 | 100% Payment |  |  | SAR | 1
 | Project #01 |  | Supplier #04 | Submitted | SAR | 1711.78 | 100% Payment |  |  | AED | 12
 | Project #01 |  | Supplier #05 | Paid | GBP (£) | 1220 | 50% Down Payment
 | Project #01 |  | Supplier #06 | Submitted | USD ($) | 0 | 50% Final Payment After Completion
 | Project #01 |  | Supplier #07 | Paid | SAR | 35183.42 | 30% Advance Payment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | \
 | Project #01 |  | Supplier #08 | On-Hold | SAR | 41260 | 23% Progress Payment |  | 0
 | Project #01 |  | Supplier #09 | Paid | EUR (€) | 30944.34782608696 | 13% Progress Payment
 | Project #01 |  | Supplier #10 | Paid | USD ($) | 20630.4347826087 | 20% Progress Payment
 | Project #01 |  | Supplier #11 | Submitted | SAR | 10317.22 | 10% After Project Handover & Snag Completion by 6 Months
 |  |  |  |  |  |  |  | TOTAL
 | P.Code | P.Name | Supplier | Status | Currency | Subtotal | Milestone
 |  |  | - | - | - | - | - | Exchange Rate | After Exchange
 | Project #02 |  | Supplier #01 | Paid | GBP (£) | 100000 | 100% Payment
 | Project #02 |  | Supplier #02 | Paid | USD ($) | 114503.1 | 100% Payment
 | Project #02 |  | Supplier #03 | Submitted | SAR | 99342.41 | 100% Payment
 | Project #02 |  | Supplier #04 | Paid | SAR | 142423.19 | 100% Payment
 | Project #02 |  | Supplier #05 | Paid | EUR (€) | 35454.16 | 50% Down Payment
 | Project #02 |  | Supplier #06 | Paid | SAR | 100000 | 50% Final Payment After Completion
 | Project #02 |  | Supplier #07 | Paid | SAR | 0 | 30% Advance Payment
 | Project #02 |  | Supplier #08 | Submitted | USD ($) | 0 | 23% Progress Payment
 | Project #02 |  | Supplier #09 | Submitted | USD ($) | 0 | 13% Progress Payment
 |  |  |  |  |  |  |  | TOTAL
 | P.Code | P.Name | Supplier | Status | Currency | Subtotal | Milestone
 |  |  | - | - | - | - | - | Exchange Rate | After Exchange
 | Project #03 |  | Supplier #01 | Paid | EUR (€) | 112201.66 | 100% Payment
 | Project #03 |  | Supplier #02 | Paid | SAR | 48770.8 | 100% Payment
 | Project #03 |  | Supplier #03 | Submitted | AED | 300000 | 100% Payment
 | Project #03 |  | Supplier #04 | Paid | SAR | 1121692.49 | 100% Payment
 | Project #03 |  | Supplier #05 | Submitted | GBP (£) | 19050 | 50% Down Payment
 | Project #03 |  | Supplier #06 | Paid | USD ($) | 19050 | 50% Final Payment After Completion
 | Project #03 |  | Supplier #07 | Paid | SAR | 285000 | 30% Advance Payment
 | Project #03 |  | Supplier #08 | Submitted | SAR | 214834.308 | 23% Progress Payment
 | Project #03 |  | Supplier #09 | Paid | EUR (€) | 125763.55 | 13% Progress Payment
 | Project #03 |  | Supplier #10 | Paid | USD ($) | 276902.142 | 29% Progress Payment
 | Project #03 |  | Supplier #11 | Paid | SAR | 47500 | 5% Final Payment After Completion | TOTAL