=SUMPRODUCT((Sheet1!A2:A40=E6)*(Sheet1!B2:B40=F6)*Sheet1!C2:C40)
问题描述：
=SUMPRODUCT((Sheet1!A2:A40=E6)*(Sheet1!B2:B40=F6)*Sheet1!C2:C40)
=SUMPRODUCT（n((Sheet1!A2:A40=E6)*(Sheet1!B2:B40=F6))*Sheet1!C2:C40)
在请问一下,下拉复制公式的时候,如何能让A2,B2,C2的数字不变,
答
=SUMPRODUCT（n((Sheet1!A$2:A$40=E6)*(Sheet1!B$2:B$40=F6))*Sheet1!C$2:C$40)