Multiplying then adding Two Rows of Numbers

[BRob]

I have two sets of numbers in Rows A and B.

I want to create a total at the end of each row along the lines of

=(A1*B1)+(A2*B2)+(A3*B3)..........+(A122*B122)

Is there a short-hand way to do it, eg via range names. If so, any
suggestions would be welcome.

Tx

 

[Rick Rothstein \(MVP - VB\)]

Give this a try...

=SUMPRODUCT((A1:A122)*(B1:B122))

Rick

 

[Mike H]

Maybe

=SUMPRODUCT(A1:A122*B1:B122)

Mike

 

[Teethless mama]

=SUMPRODUCT(A1:A10,B1:B10)