Regarding multiplication in a row

[#1]

Hi!

Lets say i have to collums in a excel file.

A                     B

500                  160

450                  160      

950                  160

I then what i expression that multiplies (500*160+450*160+950*160)=304500

I have now tested =sum(A)*sum(B) but ofc that gives me the wrong answer since it sums the row before multipling.

Thanksfull for all answers!   

[#2 · Accepted solution]

Ohh the solution is ofc sum(A*B)!

Thanks anyways!