计件金额数量汇总表(自动引入个人计件明细数据计算)品名生产 工序单价熊大熊二光头强合计数量金额数量金额数量金额数量金额成品1工序10.520001000200010002000100060003000成品2工序2210002000100020001000200030006000成品3工序30.3600018006000180060001800180005400成品4工序40.313003901300390130039039001170成品5工序50.112100231210023121002316300693成品6工序60.330009003000900300090090002700成品7工序70.1540054054005405400540162001620成品8工序80.700000000成品9工序91.500000000成品10工序100.300000000成品11工序110.500000000成品12工序120.600000000成品13工序130.800000000计件合计20800.00 6861.00 20800.00 6861.00 20800.00 6861.00 6240020583说明:一人一个计件明细表,方件个人核对数据,如需增加人数,直接复制个人明细表,另在汇总表插入对应的列数,复制公式下拉,方便实用。