内容简介:试试 =SUMPRODUCT((总清单!$M$2:$M$2100=”是“)*(总清单!$A$2:$A$2100=IF($B$2="全部",总清 单!$A$2:$A$2100,$B$2))*(总清单!$C$2:$C$2100=IF($B$3="全部",总清 单!$C$2:$C$2100,$B$3))*(总清单!$D$2:$D$2100=IF($B$4=&#34...
用户评论
voxtech