=SUM((A1:A7=A1)*(B1:B7=100)*D1:D7) 输入公式按住ctrl+shift+回车 结束
=SUMPRODUCT(($A$1:$A$7="A1")*($B$1:$B$7=100)*abs($D$1:$D$7))
