还是不会用,发个表过去帮我看一下好吗
追答=SUMPRODUCT((Sheet1!$D$4:$D$1000=Sheet2!A2)*(Sheet1!$E$4:$E$1000=Sheet2!B2)*(Sheet1!$F$4:$F$1000=Sheet2!C2))
=SUMPRODUCT((Sheet1!$D$4:$D$1000=Sheet2!A2)*(Sheet1!$E$4:$E$1000=Sheet2!B2)*(Sheet1!$F$4:$F$1000=Sheet2!C2)*(Sheet1!$G$4:$G$1000))
=SUMPRODUCT((Sheet1!$D$4:$D$1000=Sheet2!A2)*(Sheet1!$E$4:$E$1000=Sheet2!B2)*(Sheet1!$F$4:$F$1000=Sheet2!C2)*(Sheet1!$H$4:$H$1000))