Excel模板：销售统计表(月份年度汇总表)自动计算.xls

《Excel模板：销售统计表(月份年度汇总表)自动计算.xls》由会员分享，可在线阅读，更多相关《Excel模板：销售统计表(月份年度汇总表)自动计算.xls（2页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、(NEW CHHO)销销售售数数量量金金额额统统计计表表年度:2018客户ABL(USD)BLV(USD)CLV(USD)BMC(USD)BPK(USD)KBV(USD)POF(USD)MBD(USD)QAS(USD)QNM(USD)PLK(USD)XMX(USD)XXX(USD)XXX(USD)XXX(USD)XXX(USD)XXX(USD)XXX(USD)合合计计月月份份一一月月数量1,8003,96081,7583,13581,36544,7454,059220,822金额64,00854,133248,93815,097139,8343,92928,861554,801二二月月数量21

2、,83110,8071,77034,408金额42,53973,724116,263三三月月数量18,3407,40916,61359012043,072金额452,054124,130341,93410,3251,998930,441四四月月数量2,10016,565158,44212,3062,521726192,660金额76,395379,5692,828,980257,75843,23511,6893,597,625五五月月数量115,82418,610242,91919,1204,439400,912金额#473,3214,343,898406,04284,1026,931,846

3、六六月月数量68,21718,57178,10038,4868,35719,591150231,472金额960,537475,3471,417,777816,185154,610344,3873,6754,172,518七七月月数量4,6991,23576,56324,0762,4916003,330112,994金额69,73332,8631,345,228516,52845,04715,21079,6372,104,246八八月月数量56936,60112,29115,0522,0734,39070,976金额12,086680,180264,317275,466104,6871,336

4、,736九九月月数量15,92715,927金额286,886286,886十十月月数量152,2711,058153,329金额2,619,7172,619,717十十一一月月数量7,9907988,788金额116,67412,888129,562十十二二月月数量960960金额21,41021,410小小计计数量1,8003,960270,49860,460720,976166,1384,05934,55522,3847,8709601,293,660金额140,40354,133#1,840,337 13,945,8432,680,41728,861625,673373,283187,

5、99921,410#(2018)月份一月二月三月四月五月六月七月八月九月十月十一月十二月合计合合计计数量220,82234,40843,072192,660400,912231,472112,99470,97615,927153,3298,788961,485,456USD554,801116,263930,4413,597,6256,931,8464,172,518 2,104,246#286,886 2,619,717129,5622,141USD22,782,781汇率6.4126.416.12456.316.4086.416.3566.4216.416.46.4156.413RMB#745,245#22,701,014 44,419,272 26,745,838#831,13913,729总计RMB145,274,999合合计计