=SUMPRODUCT(($A$2:$A$100=“M5×16”)*($B$2:$B$100="内六角圆头螺钉")*($C$2:$C$100))如果在另一个表中显示结果，则：=SUMPRODUCT((Sheet1!$A$2:$A$100=“M5×16”)*(Sheet1!$B$2:$B$100="内六角圆头螺钉")*(Sheet1!$C$2:$C$100))
