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
|