Spreadsheet: 119335d1314326292-sum-according-to-month-and-supplier-example
Sheet: DATA

Item_No | Main_Desc1 | PO_Date | PO_No | Supplier_No | PO_Currency | PO_Price | PO_Qty | PO_Total | Conv. Total | Conv. Pc.
916.96.006 | xxxx | 2010-10-01 00:00:00 | 1 | s1 | US$ | 3.3 | 1000 | 3300 | 3300 | 3.3
916.96.206 | xxxx | 2010-10-01 00:00:00 | 2 | s1 | US$ | 2.8 | 50 | 140 | 140 | 2.8
916.96.216 | xxxx | 2010-10-01 00:00:00 | 3 | s1 | US$ | 2.9 | 200 | 580 | 580 | 2.9
833.74.724 | xxxx | 2010-10-14 00:00:00 | 4 | s2 | US$ | 0.26 | 50 | 13 | 13 | 0.26
833.73.340 | xxxx | 2010-10-14 00:00:00 | 5 | s3 | US$ | 27.2 | 30 | 816 | 816 | 27.2
833.73.400 | xxxx | 2010-10-14 00:00:00 | 6 | s3 | US$ | 37.4 | 30 | 1122 | 1122 | 37.4
833.73.400 | xxxx | 2010-10-14 00:00:00 | 7 | s3 | US$ | 37.4 | 30 | 1122 | 1122 | 37.4
433.10.745 | xxxx | 2010-11-17 00:00:00 | 8 | s4 | US$ | 4.366 | 300 | 1309.8 | 1309.8 | 4.366
433.10.755 | xxxx | 2010-11-17 00:00:00 | 9 | s4 | US$ | 4.956 | 180 | 892.08 | 892.08 | 4.956
554.65.705 | xxxx | 2010-11-17 00:00:00 | 10 | s4 | US$ | 0.64 | 2325 | 1488 | 1488 | 0.64
015.71.811 | xxxx | 2010-11-17 00:00:00 | 11 | s5 | US$ | 0.00254 | 50000 | 127 | 127 | 0.00254
262.28.624 | xxxx | 2010-11-17 00:00:00 | 12 | s5 | US$ | 0.0114 | 700000 | 7980 | 7980 | 0.0114
264.40.191 | xxxx | 2010-11-17 00:00:00 | 13 | s5 | US$ | 0.0092 | 50000 | 460 | 460 | 0.0092
264.42.197 | xxxx | 2010-11-17 00:00:00 | 14 | s5 | US$ | 0.0132 | 40000 | 528 | 528 | 0.0132
264.44.190 | xxxx | 2010-11-17 00:00:00 | 15 | s5 | US$ | 0.0137 | 200000 | 2740 | 2740 | 0.0137
264.76.130 | xxxx | 2010-11-17 00:00:00 | 16 | s5 | US$ | 0.0186 | 84000 | 1562.4 | 1562.4 | 0.0186
264.76.170 | xxxx | 2010-11-17 00:00:00 | 17 | s5 | US$ | 0.0322 | 20700 | 666.54 | 666.54 | 0.0322
264.76.330 | xxxx | 2010-11-17 00:00:00 | 18 | s5 | US$ | 0.01373 | 10000 | 137.3 | 137.3 | 0.01373
264.85.014 | xxxx | 2010-11-17 00:00:00 | 19 | s5 | US$ | 0.047 | 70000 | 3290 | 3290 | 0.047
267.10.116 | xxxx | 2010-11-17 00:00:00 | 20 | s5 | US$ | 0.0301 | 50000 | 1505 | 1505 | 0.0301
634.62.224 | xxxx | 2010-11-17 00:00:00 | 21 | s6 | US$ | 1.5038 | 5000 | 7519 | 7519 | 1.5038
634.65.250 | xxxx | 2010-11-17 00:00:00 | 22 | s6 | US$ | 1.26459 | 500 | 632.295 | 632.295 | 1.26459
284.01.233 | xxxx | 2010-11-17 00:00:00 | 23 | s10 | US$ | 1.496 | 1700 | 2543.2 | 2543.2 | 1.496
903.XX.419 | xxxx | 2010-11-30 00:00:00 | 24 | s10 | US$ | 143 | 3 | 429 | 429 | 143
903.XX.610 | xxxx | 2010-11-30 00:00:00 | 25 | s10 | US$ | 90.9 | 10 | 909 | 909 | 90.9
835.XX.004 | xxxx | 2010-11-30 00:00:00 | 28 | s31 | RMB | 1300 | 10 | 13000 | 1950 | 195
835.XX.001 | xxxx | 2010-11-30 00:00:00 | 29 | s32 | RMB | 669.8 | 10 | 6698 | 1004.7 | 100.47
588.06.XX0 | xxxx | 2010-11-30 00:00:00 | 30 | s33 | US$ | 192 | 1 | 192 | 192 | 192
421.38.730 | xxxx | 2010-12-01 00:00:00 | 31 | s4 | US$ | 4.152 | 1350 | 5605.2 | 5605.2 | 4.152
423.08.236 | xxxx | 2010-12-01 00:00:00 | 32 | s4 | US$ | 0.495 | 20160 | 9979.2 | 9979.2 | 0.495
423.08.246 | xxxx | 2010-12-01 00:00:00 | 33 | s4 | US$ | 0.617 | 10800 | 6663.6 | 6663.6 | 0.617
423.08.346 | xxxx | 2010-12-01 00:00:00 | 34 | s4 | US$ | 0.617 | 4800 | 2961.6 | 2961.6 | 0.617
558.50.256 | xxxx | 2010-12-01 00:00:00 | 35 | s4 | US$ | 2 | 320 | 640 | 640 | 2
284.01.051 | xxxx | 2010-12-01 00:00:00 | 42 | s10 | US$ | 0.532 | 10000 | 5320 | 5320 | 0.532
373.82.001R1 | xxxx | 2010-12-01 00:00:00 | 44 | s9 | US$ | 0.6 | 4500 | 2700 | 2700 | 0.6
373.82.002R1 | xxxx | 2010-12-01 00:00:00 | 45 | s9 | US$ | 0.6 | 4500 | 2700 | 2700 | 0.6
373.82.003R1 | xxxx | 2010-12-01 00:00:00 | 46 | s9 | US$ | 0.6 | 6000 | 3600 | 3600 | 0.6
536.06.005 | xxxx | 2010-12-01 00:00:00 | 47 | s8 | US$ | 77.4 | 300 | 23220 | 23220 | 77.4
536.06.015 | xxxx | 2010-12-01 00:00:00 | 48 | s8 | US$ | 90.1 | 200 | 18020 | 18020 | 90.1
536.06.211 | xxxx | 2010-12-01 00:00:00 | 49 | s8 | US$ | 60.4 | 50 | 3020 | 3020 | 60.4
536.86.403 | xxxx | 2010-12-01 00:00:00 | 50 | s8 | US$ | 90.2 | 100 | 9020 | 9020 | 90.2
536.86.423 | xxxx | 2010-12-01 00:00:00 | 51 | s8 | US$ | 112.2 | 250 | 28050 | 28050 | 112.2
911.02.153 | xxxx | 2010-12-01 00:00:00 | 52 | s7 | US$ | 4.51 | 3000 | 13530 | 13530 | 4.51
916.96.006 | xxxx | 2010-12-11 00:00:00 | 1 | s1 | US$ | 3.3 | 1000 | 3300 | 3300 | 3.3