D2公式:
=SUMPRODUCT((Sheet1!$B$1:$B$999=A2)*(Sheet1!$E$1:$E$999=B2)*(Sheet1!$G$1:$G$999=C2),Sheet1!$L$1:$L$999)
或
=SUMPRODUCT((Sheet1!$B$1:$B$999="张三")*(Sheet1!$E$1:$E$999="Φ18*1.6m")*(Sheet1!$G$1:$G$999="100*100*6mm"),Sheet1!$L$1:$L$999)
本文如未解决您的问题请添加抖音号:51dongshi(抖音搜索懂视),直接咨询即可。