Multiplying two rows together

[Lee Harris]

If I have a set of coefficients in Row 1 B1:Z1 for example
and data values in Rows 2-N eg B2:Z2, B3:Z3, ...Bn:Zn

What's the proper way to have in Cell A(n) such that I sum each number in
the row by the corresponding coefficient

I mean, instead of having it like this


A2 = (B$1*B2)+(C$1*C2)+(D$1*D2)+(E$1*E2)+.....

Is this an array formula of some kind that I need?

 

[Lee Harris]

If I have a set of coefficients in Row 1 B1:Z1 for example
and data values in Rows 2-N eg B2:Z2, B3:Z3, ...Bn:Zn

What's the proper way to have in Cell A(n) such that I sum each number in
the row by the corresponding coefficient

I mean, instead of having it like this


A2 = (B$1*B2)+(C$1*C2)+(D$1*D2)+(E$1*E2)+.....

Is this an array formula of some kind that I need?

never mind, I gave SUMPRODUCT a try and this format seemed to work

=SUMPRODUCT(H38:R38,H40:R40)+SUMPRODUCT(T40:AE40,T38:AE38)

 

[Bob Phillips]

=SUMPRODUCT(B1:M1,B2:M2)

--

HTH

RP
(remove nothere from the email address if mailing direct)