Sum up rows using multiple columns

[JustAnotherFella]

Posting an example ( Also attached the screenshot so that its more clearer

Col1 Col2
2 10
3 10
4 30
3 20
1 5
2 15

Total Sum 265

the Col1 is in "B" and Col2 is on "C" columns

The formula for getting 265 is =B5*C5+B6*C6+B7*C7+B8*C8+B9*C9+B10*C10

Question : Is there an easier way to write the formula as its difficult if there are many rows. Also do not want to create another column.

screeshot.jpg
----------------------------------

[seasider89]

=sumproduct(b5:b10,c5:c10)

[JustAnotherFella]

Thanks a lot seasider89. Great help.