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?