Question

EXCEL中=B2*B3+c2*C3+D2*D3+E2*E3直到+Z2*Z3这个公式怎么写

Answer 1

直接将下面的公式粘贴过去即可:
=SUMPRODUCT(B2:Z2,B3:Z3)

Answer 2

=SUMPRODUCT((B2:Z2)*(B3:Z3))

Answer 3

=SUMPRODUCT(N(INDIRECT(CHAR(COLUMN(B:Z)+64)&"2"))*N(INDIRECT(CHAR(COLUMN(B:Z)+64)&"3")))