Excel: Scalar product of two ranges

[ForumBot]

I am trying to find a proper way to calculate the scalar product of two ranges. For instance, the product of A1:A3 and B1:B3 would be A1*B1 + A2*B2 + A3*B3. Is there a good way to do this? Hardcoding this calculation is quite a tedious thing to do with large ranges.

[ayi]

Use this one

=SUMPRODUCT(A1:A3,B1:B3)