求excel公式,用excel算加總?

http://blog.xuite.net/hcm19522/twblog/495522364

1.要怎麼用excel公式算出編號1的a加總,
=SUMPRODUCT(($A$2:$A$100=1)*$B$2:$B$100)
2.要怎麼用excel公式算出編號2的a+c+e
=SUMPRODUCT(($A$2:$A$100=2)*(($B$2:$B$100)+($D$2:$D$100)+($F$2:$F$100)))
3.要怎麼用excel公式算出編號3的X+Y+Z平均值
=SUMPRODUCT(($A$2:$A$100=3)*($C$2:$C$100+$E$2:$E$100+$G$2:$G$100))/COUNTIF(A2:A100,3)
4.要怎麼用excel公式算出編號4、5的a+c+e
=SUMPRODUCT(($A$2:$A$100={4,5})*($B$2:$B$100+$D$2:$D$100+$F$2:$F$100))