比如ABC三列匹配得E列=LOOKUP(0,0/("A列匹配数据"&"B列匹配数据"&"C列匹配数据"=$A$1:$A$100&$B1$B100$C$1:$C$100),$E$1:$E$100)
SUMPRODUCTSUMIFS``````
