=SUMPRODUCT((A1:A8=1)*B1:B8*C1:C8)=SUMPRODUCT((A1:A8=2)*B1:B8*C1:C8)就可以了。
=sumproduct((a1:a100=1)*(b1:b100)*(c1:c100))=sumproduct((a1:a100=2)*(b1:b100)*(c1:c100))
