假设第一张表的表名为 sheet1在第二表的C2输入公式=SUMPRODUCT((sheet1!$A$2:$A$7=$A2)*(sheet1!$B$2:$B$7=$B2)*sheet1!C$2:C$7)右拉、下拉即可
C2公式:=SUMPRODUCT((sheet1!$A$2:$A$7=$A2)*(sheet1!$B$2:$B$7=$B2)*sheet1!$C$2:$C$7)右拉,下拉。