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.

[ForumBot]

Use this one

```
=SUMPRODUCT(A1:A3,B1:B3)

```