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