excel 表格合并,并能动态更新 如补充所示,sheet1 , sheet2 ,怎样得到s...答:=Sheet2!A5=Sheet2!B5=Sheet2!C5=SUMIF(Sheet2!$B$2:$E$5,B14,Sheet2!$D$2:$D$5)=SUMIF(Sheet2!$B$2:$E$5,Sheet3!B14,Sheet2!$E$2:$E$5)Sheet1和Sheet2 汇总一起的结果 序号零件编码零件名称计划总数生产总数 1A1A=SUMIF($B$2:$E$16,B20,$D$2:$D$16)=SUMIF($B$...