title: Excel SUMPRODUCT and MMULT with condition
body: <p>Hello I need to make a <code>sumproduct</code> with general conditions.
  The correct values is shown in cell <code>B6</code>, <code>B7</code> and <code>B8</code></p>
  
  <p>In cell <code>B6</code> I have this formula <code>=A1*A2+B1*B2+C1*C2</code> to understand what is the result that I expected.<br>
  In <code>B7</code> is <code>=D1*D2+E1*E2</code> and so on...</p>
  
  <p><a href="https://i.stack.imgur.com/F6Iqj.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/F6Iqj.png" alt="enter image description here"></a></p>
  
  <p>I've tried with this formula <code>=SUMPRODUCT(A3:G3=A6,A1:G1,A2:G2)</code> in cell <code>B6</code> but the result is 0. </p>