Ce site est optimisé pour être consulté depuis un navigateur moderne dans lequel JavaScript est activé.

Excel: Scalar product of two ranges

ayi

<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>A1B1 + A2B2 + 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>

ayi_2

<p>Use this one</p>
<pre><code class="lang-auto">=SUMPRODUCT(A1:A3,B1:B3)

</code></pre>