求助诸位EXCEL函数大神们:IF函数,嵌套AND及SUMPRODUCT函数IF(AND(C86=C85,D86=D85,E86=E85),"",SUMPRODUCT(($C$2:$C$859=C86)*($D$2:$D$859=D86)*($E$2:$E$859=E86)*($I$2:$I$859))),只看明白了是一个筛选,但没弄懂,

来源:学生作业帮助网 编辑:作业帮 时间:2024/11/05 15:13:07
xU[OA+ I)&4Hb%i-*(CWt[*BR)"XK ̙>f- jL&f7;99gvhrX|ĶSqk>7Un4#JK62Wo(3z훡] x/^ V 68c== ^%_$JBJIJ4% KIXJ|>ԎZdgEgDk^۱rHqkF|*PcZĦ}-Yϸorx?+p@Q4kEiogf~vJ/A9zGzk ׅ&yJv'Na.{XYУ' J|c:u۷H 7AFB; I#?iKbi)ÍJS .mrTNjSgsK U5]δThyru*/1OWbA: Ek^jƒNQIɝfLQ`y}x2NՐn{tR&V#77zx~`vzF!>ZQD"RQݽ=h+BOcX~U6mA3,$*O; 5j}"Va6aL[u[7{JN?z W? =ը>9:AefHB%txT%J|<*?B߁R УJavShye]yykkpkKb*%Qx4|EK9ʔjMG:GF\*:[`jY&qVR\PYaU%V9'e;*#'fp$M=U?