加總 二二相乘 (9117)

C3=SUMPRODUCT(D3:P3*E3:Q3*MOD(COLUMN(E:Q),2))

另解=SUMPRODUCT(N(OFFSET(D3,,2*ROW($1:$8)-2)),N(OFFSET(E3,,2*ROW($1:$8)-2)))

另解=SUMPRODUCT(D3:ZZ3*E3:AAA3*ISODD(COLUMN(C3:ZY3)))

另解=SUMPRODUCT(D3:P3*E3:Q3*(LEFT(D$2:P$2,2)="单价"))