求EXCEL表中,不同行乘同一行再求和的公式,比如A1*A2+B1*B2+C1*C2 A1*A3+B1*B3+C1*C3 A1*A4+B1*B4+C1*C4

=SUM(SUMPRODUCT(A1:C1,A2:C2),SUMPRODUCT(A1:C1,A3:C3),SUMPRODUCT(A1:C1,A4:C4))