sumproduct函数结果为什么是N/A=sumproduct(($w$2:$w$2000=a2)*($x$2:$x$2000=b2)*$p$2:$p$20

推荐回答

查找符合２个条件的值查找与右表中品名和型号相符的代码，返回相应的值？＝可以在表1增加辅助列，表2用vlookup引用，如附件所示 ：或=SUMPRODUCT((A2=Sheet1!$A$2:$A$15)*(B2=Sheet1!$B$2:$B$15)*Sheet1!$C$2:$C$15)一个条件，用vlookup；多个条件，用数组：sumproduct就是数组，在a2:a15里面找a2,b2:b15里面找b2,然后在c2:c15里面找到满足条件的值=INDEX(Sheet1!$C$2:$C$15,MATCH(Sheet2!A2&Sheet2!B2,Sheet1!$A$2:$A$15&Sheet1!$B$2:$B$15,))数组公式。=LOOKUP(1,0/((A2=Sheet1!$A$2:$A$15)*(Sheet2!B2=Sheet1!$B$2:$B$15)),Sheet1!$C$2:$C$15)