在第三工作表的A2列输入品名,C2列输入厂家编号,F2输入=SUMIFs(sheet1!F2:F500,Sheet1!A2:A500,A2,Sheet1!C2:C500,C2)+SUMIFs(sheet2!F2:F500,Sheet2!A2:A500,A2,Sheet2!C2:C500,C2)