ExcelBanter - Multiplying then adding Two Rows of Numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiplying then adding Two Rows of Numbers (https://www.excelbanter.com/excel-worksheet-functions/189056-multiplying-then-adding-two-rows-numbers.html)

BRob

Multiplying then adding Two Rows of Numbers

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\)[_542_]

Multiplying then adding Two Rows of Numbers

Give this a try...

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

Rick

"BRob" wrote in message
...
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

Mike H

Multiplying then adding Two Rows of Numbers

Maybe

=SUMPRODUCT(A1:A122*B1:B122)

Mike

"BRob" wrote:

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

Teethless mama

Multiplying then adding Two Rows of Numbers

=SUMPRODUCT(A1:A10,B1:B10)

"BRob" wrote:

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

All times are GMT +1. The time now is 09:30 AM.