=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!$E$2:$V$2=$B5)*Sheet1!$E$6: =sumproduct(sheet1!c2:c1000=重庆)*(sheet1!k2:K2:k1000=已买）*(sheet1!h2:h1000=重庆!a3)) a3日期 SUMPRODUCT函数=SUMPRODUCT((Sheet1!A2:A40=E6)*(Sheet1!B2:B40=F6)*Sheet1!C2:C40)为错鋘,如果改所有40为30才能计算正确,有没有办法计算到A1000啊 =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(INDIRECT(sheet1!E&(ROW($1:$1063)-1)*35+25))) 关于excel函数公式问题请指点SUMPRODUCT((Sheet2!C4:C18=Sheet1!B1)*(Sheet2!D4:D18=Sheet1!b4)*Shee这是表1这是表2 计算结果在表2 的C4＝SUMPRODUCT((Sheet2!C4:C18="Sheet1!B1")*(Sheet2!D4:D18="Sheet1!b4")*Sheet 这个函数公式是什么意思的?=IF(SUMPRODUCT((Sheet1!B$2:B$312=B2)*(Sheet1!C$2:C$312=C2)*(Sheet1!L$2:L$312=L2)*(Sheet1!M$2:M$312=M2)*(Sheet1!P$2:P$312=P2))=1,,不同)我是函数公式门外汉, sumproduct公式返回值为0,=-SUMPRODUCT(([RO.xls]Sheet1!$A$2:$A$315=C27)*([RO.xls]Sheet1!$B$2:$B$315=B27)*[RO.xls]Sheet1!$D$2:$D$315)当表RO中的A列等于C27,B列等于B27（与C27一样,都为数值,如500660、101367等）,求D列的和 =SUMPRODUCT(Sheet1!B3:B3109=背心)*(Sheet1!J3:J3109>0)我用了这个函数,得到的结果#NAME?请问这是怎么回事呢?我想得出B列含有“背心”,J列大于0的单元数 =lookup(A1,sheet1!A:A,sheet1!B:B)中的A1是什么意思,sheet1!A:sheet1!B: =SUMPRODUCT怎么应用 =SUMPRODUCT((A1:A8 =OFFSET(Sheet1!$A$1,Sheet1!$E$1-1, sumproduct函数 =sumproduct((mod(a2:a13,7) SHEET2 B1=SHEET1!B7 SHEET2 C1=SHEET1!B8 SHEET2 B2=SHEET1!B10 SHEET2 C2=SHEET1!B11 以此类推 EXCEL里如果A1＝SHEET1中的A1-A100,那么B1就显示SHEET1表中的B1-B100的内容,在B1中的公式应该如何写?IF :A1=SHEET1,A1,那么：B1=SHEET1,B1IF :A2=SHEET1,A2,那么：B2=SHEET1,B2IF :A3=SHEET1,A3,那么：B3=SHEET1,B3IF :A4=SHEET1,A 我要使得sheet2中 A1=sheet1!B1,A2=sheet1!B13,A3=sheet1!B25,A4=sheet1!B37依次类推到A500有我要使得sheet2中 A1=sheet1!F4,A2=sheet1!F16,A3=sheet1!B28,A4=sheet1!B40依次类推到A500 有什么办法? EXCEL里如果SHEET2中A1＝SHEET1中的A1-A100,那么B1就显示SHEET1表中的B1-B100的内容,在B1中的公式如何写IF :A1=SHEET1的A1,那么：B1=SHEET1,B1IF :A1=SHEET1的A2,那么：B1=SHEET1,B2IF :A1=SHEET1的A3,那么：B1=SHEET1,B3IF :A1=