Question

函数应用求高手指教，非常感谢！

sheet2!C1"=SUMPRODUCT((sheet1!A:A=sheet2!A1)*(sheet1!B:B=sheet2!B1)*(sheet1!C:C=sheet2!C1)*(sheet1!D:D))"错在哪里？求高手指教，谢谢！

Answer 1

如果你是用2003以上的EXCEL版本,则公式没错
=SUMPRODUCT((Sheet1!A:A=Sheet2!A1)*(Sheet1!B:B=Sheet2!B1)*(Sheet1!C:C=Sheet2!C1)*Sheet1!D:D)

如果是用03版的EXCEL则公式中引用的单元格区域要有具体的行号,我假设数据在第1行至第100行区域,则公式为
=SUMPRODUCT((Sheet1!A$1:A$100=Sheet2!A1)*(Sheet1!B$1:B$100=Sheet2!B1)*(Sheet1!C$1:C$100=Sheet2!C1)*Sheet1!D$1:D$100)

请注意在Sheet1!D:D(或Sheet1!D1:D100)单元格区域不能有非数字的内容

Answer 2

=SUMPRODUCT((sheet1!A$1:A$6=A1)*(sheet1!B$1:B$6=B1),sheet1!C$1:C$6)