您的位置: 首页  >  作业答案  >  其他  >  =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((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的数字不变,

分类: 作业答案 • 2022-07-18 12:31:47
问题描述：

=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)

相关推荐