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