=SUMPRODUCT(--($P$4:$P$46="V"),I5:I47)
Example2: http://isvincent.pixnet.net/blog/post/28281318-excel-sumproduct%E5%87%BD%E6%95%B8%E6%87%89%E7%94%A8
=SUMPRODUCT(($A$3:$A$25=$E3)*1,($B$3:$B$25=F$2)*1,$C$3:$C$25)
=SUMPRODUCT(--($P$4:$P$46="V"),I5:I47)
Example2: http://isvincent.pixnet.net/blog/post/28281318-excel-sumproduct%E5%87%BD%E6%95%B8%E6%87%89%E7%94%A8
=SUMPRODUCT(($A$3:$A$25=$E3)*1,($B$3:$B$25=F$2)*1,$C$3:$C$25)
沒有留言:
張貼留言