Sumproduct example

=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)

[轉] 推薦！國外工程師整理的系統管理員資源大全

http://buzzorange.com/techorange/2015/05/07/data/