Spreadsheet: 455494d1460375612-sum-if-with-index-and-match-sample
Sheet: Sheet2

City | Customer | Size | Order Quantity |  | Dispatch Quantity
 |  |  | No. | Box | No. | Box
Goa | Sharma-1 | 200 | 8000 | 255.76 | 7756.5 | 247.975305
Goa | Sharma-1 | 300 | 17500 | 943.95 | 16203 | 873.9898199999999
Goa | Sharma-1 | 300 | 9300 | 441.471 | 1116 | 52.97651999999999
Goa | Sharma-1 | 300 | 2000 | 94.94 | 1824 | 86.58528
Goa | Sharma-1 | 300 | 5100 | 275.094 | 5100 | 275.094
Goa | Sharma-1 | 250 | 6003 | 257.04846 | 6003 | 257.04846
Goa | Sharma-1 | 250 | 5200 | 195.988 | 0 | 0
Goa | Sharma-2 | 300 | 10600 | 503.182 | 0 | 0
Goa | Sharma-2 | 300 | 14000 | 664.58 | 0 | 0
Goa | Sharma-2 | 300 | 5000 | 269.7 | 4235 | 228.4359
Goa | Sharma-2 | 300 | 1000 | 47.47 | 692 | 32.84923999999999
Goa | Sharma-3 | 200 | 1296 | 36.45648 | 0 | 0
Goa | Sharma-3 | 200 | 20000 | 562.6 | 7776 | 218.73888
Goa | Sharma-3 | 200 | 7944 | 223.46472 | 6000 | 168.78
Goa | Sharma-3 | 200 | 6000 | 168.78 | 1000 | 28.13
Goa | Sharma-4 | 250 | 3500 | 131.915 | 960 | 36.18239999999999
Goa | Sharma-4 | 250 | 114 | 4.29666 | 113 | 4.25897
Goa | Sharma-4 | 250 | 1440 | 54.2736 | 1440 | 54.2736
Goa | Sharma-4 | 300 | 1926 | 91.42722 | 0 | 0
Goa | Sharma-5 | 300 | 4000 | 189.88 | 1988 | 94.37036
Goa | Sharma-5 | 300 | 204 | 9.683879999999998 | 204 | 9.683879999999998
Goa | Sharma-5 | 300 | 3500 | 188.79 | 0 | 0
Goa | Gupta-1 | 200 | 3000 | 84.39 | 0 | 0
Goa | Gupta-2 | 200 | 3000 | 84.39 | 1296 | 36.45648
Goa | Gupta-2 | 200 | 3000 | 84.39 | 0 | 0
Kerala | Peter-1 | 300 | 20000 | 949.4 | 0 | 0
Kerala | Peter-12 | 200 | 8000 | 225.04 | 0 | 0
Kerala | Peter-12 | 250 | 1224 | 46.13256 | 0 | 0
Kerala | Peter-12 | 200 | 0 | 0 | 0 | 0
Kerala | Peter-12 | 300 | 0 | 0 | 0 | 0
Kerala | Peter-12 | 200 | 0 | 0 | 0 | 0
Kerala | Peter-12 | 300 | 0 | 0 | 0 | 0
Kerala | Peter-15 | 200 | 12 | 0.38364 | 12 | 0.38364
Kerala | Robot-1 | 300 | 6 | 0.32364 | 6 | 0.32364
Kerala | Robot-1 | 300 | 3000 | 161.82 | 3000 | 161.82
Kerala | Robot-1 | 250 | 42 | 1.79844 | 42 | 1.79844
Kerala | Robot-3 | 250 | 11 | 0.47102 | 11 | 0.47102
Kerala | Robot-4 | 300 | 12 | 0.64728 | 12 | 0.64728
Kerala | Robot-4 | 250 | 5.5 | 0.23551 | 5.5 | 0.23551
Kerala | Robot-4 | 300 | 3000 | 161.82 | 3000 | 161.82
Kerala | Robot-5 | 300 | 30 | 1.6182 | 30 | 1.6182
Kerala | Thomas-45 | 200 | 90 | 2.8773 | 90 | 2.8773
Kerala | Thomas-45 | 200 | 24 | 0.76728 | 24 | 0.76728
Kerala | Thomas-45 | 200 | 12 | 0.38364 | 12 | 0.38364
Kerala | Thomas-4 | 200 | 12 | 0.38364 | 12 | 0.38364
UP | Kumar-11 | 300 | 1000 | 53.94 | 1000 | 53.94
UP | Kumar-11 | 200 |  | 0 | 0 | 0
UP | Kumar-11 | 200 | 12 | 0.38364 | 12 | 0.38364
UP | Kumar-11 | 300 | 120 | 6.472799999999999 | 120 | 6.472799999999999
UP | Kumar-11 | 300 | 1002 | 54.04788 | 1002 | 54.04788
UP | Kumar-13 | 200 | 11498 | 281.58602 | 11498 | 281.58602
UP | Kumar-13 | 300 | 420 | 19.7442 | 420 | 19.7442
UP | Kumar-13 | 300 | 7350 | 396.459 | 7350 | 396.459
UP | Kumar-13 | 300 | 159.5 | 8.60343 | 159.5 | 8.60343
UP | Kumar-15 | 200 | 5500 | 134.695 | 5500 | 134.695
UP | Kumar-15 | 200 | 960 | 23.5104 | 960 | 23.5104
UP | Kumar-15 | 200 | 9000 | 220.41 | 0 | 0
UP | Kumar-15 | 200 | 3000 | 73.47 | 0 | 0
UP | Madhav-10 | 250 | 1800 | 72.918 | 0 | 0
UP | Madhav-9 | 300 | 2400 | 112.824 | 0 | 0
UP | Madhav-8 | 200 | 8250 | 202.0425 | 0 | 0
UP | Madhav-8 | 200 | 3000 | 73.47 | 0 | 0
UP | Madhav-8 | 200 | 660 | 21.1002 | 660 | 21.1002
UP | Madhav-7 | 250 | 1797 | 63.41613 | 1797 | 63.41613
UP | Madhav-7 | 300 | 240 | 12.9456 | 240 | 12.9456
UP | Madhav-7 | 250 | 924 | 39.56568 | 924 | 39.56568
UP | Madhav-7 | 300 | 462 | 24.92028 | 462 | 24.92028
UP | Tripati-5 | 200 | 1760 | 43.1024 | 1760 | 43.1024
UP | Tripati-5 | 250 | 6160 | 217.3864 | 6160 | 217.3864
UP | Tripati-6 | 300 | 2486 | 116.86686 | 2486 | 116.86686
UP | Tripati-6 | 200 | 1001 | 24.51449 | 0 | 0
UP | Tripati-6 | 250 | 3080 | 108.6932 | 3080 | 108.6932
UP | Tripati-6 | 300 | 1001 | 47.05701 | 0 | 0
UP | Tripati-7 | 250 | 1232 | 43.47728 | 1232 | 43.47728
UP | Tripati-7 | 200 | 300 | 9.591 | 0 | 0
UP | Tripati-7 | 250 | 4140 | 177.2748 | 0 | 0
UP | Tripati-8 | 300 | 35000 | 1887.9 | 3500 | 188.79
UP | Tripati-8 | 300 | 5700 | 307.458 | 0 | 0
UP | Tripati-8 | 200 | 7480 | 183.1852 | 7480 | 183.1852
UP | Tripati-8 | 300 | 3696 | 199.36224 | 3696 | 199.36224
MP | Nayar-99 | 200 | 6000 | 155.4 | 5995 | 155.2705
MP | Nayar-97 | 250 | 7000 | 238.84 | 7000 | 238.84
MP | Nayar-97 | 250 | 308 | 11.60852 | 308 | 11.60852
MP | Nayar-97 | 250 | 2244 | 96.08808 | 0 | 0
MP | Nayar-91 | 200 | 891 | 28.48527 | 891 | 28.48527
MP | Rana-01 | 200 | 1140 | 27.9186 | 0 | 0