请帮忙用嵌套或其它函数简化下sumifs函数的公式

开心逗留

合计D列1#和2#流水线 N列早班 M列男 的C列的产量
=SUMIFS($C$2:$C$200,$M$2:$M$200,"男",$N$2:$N$200,"早班",$D$2:$D$200,"1#流水线")+SUMIFS($C$2:$C$200,$M$2:$M$200,"男",$N$2:$N$200,"早班",$D$2:$D$200,"2#流水线")

度娘上未得到回复，帮忙看看能不能用if or之类函数嵌套简化下公式，谢谢！

kuangben8

=sum(SUMIFS($C$2:$C$200,$M$2:$M$200,"男",$N$2:$N$200,"早班",$D$2:$D$200,{"1#流水线","2#流水线",}))

数组公式

开心逗留

kuangben8 发表于 2015-3-6 14:17
=sum(SUMIFS($C$2:$C$200,$M$2:$M$200,"男",$N$2:$N$200,"早班",$D$2:$D$200,{"1#流水线","2#流水线",}))
...

eh大神太给力了，原来数组是这么用的，非常感谢！