=SUMPRODUCT(($A$2:$A$200="网络部")*($B$2:$B$200="圆珠笔")*(MONTH($D$2:$D$200)>4)*$C$2:$C$200)
excel2010的问题,多个条件统计的问题.
4)*" property="og:description"/>
=SUMPRODUCT(($A$2:$A$200="网络部")*($B$2:$B$200="圆珠笔")*(MONTH($D$2:$D$200)>4)*$C$2:$C$200)