制造销售前10供应商分析自动公式.xls

应收销售明细序号单据类型应收单号客户简称日期品号品名规格单位数量单价金额成本成本金额备注1应收单1101-202002010001智光2020-2-111001101空调105AD1202台501482741001200600002应收单1101-202002010002惠而普2020-2-211001101空调105AD1202台351390486501200420003应收单1101-202002010003华社2020-2-311001101空调105AD1202台361700612001200432004应收单1101-202002010004兴达2020-2-411001101空调105AD1202台281620453601200336005应收单1101-202002010005国通2020-2-511001101空调105AD1202台501520760001200600006应收单1101-202002010006三奇2020-2-611001101空调105AD1202台6915301055701200828007应收单1101-202002010007贵联2020-2-711001101空调105AD1202台611495911951200732008应收单1101-202002010008绿智2020-2-811001101空调105AD1202台481650792001200576009应收单1101-202002010009正太2020-2-911001101空调105AD1202台5015107550012006000010应收单1101-202002010010力丰2020-2-1011001101空调105AD1202台2915204408012003480011应收单1101-202002010011兴达2020-2-1111001101空调105AD1202台2015303060012002400012应收单1101-202002010012国通2020-2-1211001101空调105AD1202台5614808288012006720013应收单1101-202002010013三奇2020-2-1311001101空调105AD1202台15147022050120018000备注：成本可以通过VLOOKUP函数引用成本单价