Formula to multiplie cells and then add up

Hello,
I'm want to make a total of two rows that should multiply with each other first so the formula can look like this:

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

This works, but it's over 100 rows, so the formula is too long to handle. Is there an easier way of writing this?

Hi,

This is not working. Or I don't understand how you mean I should use this. What does the 1 and 2 stand for?
I might have been a bit unclear. There are 50 rows, A1:A50 where A1 should multiply with B2, A2 with B2 and so on. The total of all multiplications should then add up to a total at the bottom of column B.

Is there a way of writing this without having to write the calculation for each single row (e.g. =(A1*B1)+(A2*B2)... etc)?

Fantastic!

Thanks a million!

Fantastic!

Thanks a million!