方法一：=COUNTIFS($A$2:$A$17,$I2,$B$2:$B$17,J$1,$F$2:$F$17,"<>"&"未发货")
countifs多条件统计
方法二：'=SUMPRODUCT(($A$2:$A$17=$I2)*($B$2:$B$17=J$1)*($F$2:$F$17<>"未发货"))
sumproduct多条件统计
=sum(countifs(a:a,"事业二部",b:b,2019,f:f,{"已发货","施工中","已完工"}))
ctrl+shift+回车
输入以下公式之一，按Enter键结束
=SUMPRODUCT((A2:A200="事业二部")*(B2:B200=2019)*(OR(F2:F200={"已发货","施工中","已完工"}))
=SUMPRODUCT((A2:A200="事业二部")*(B2:B200=2019)*(F2:F200<>"未发货"))
=COUNTIFS(A:A,"事业二部",B:B,2019,F:F,"<>未发货")
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024