title: sumproduct, fix one array
body: <p>I have two columns I do the sumproduct operation on them this way:</p>
  
  <pre><code>=SUMPRODUCT(I37:I61, **D37:D61**)
  </code></pre>
  
  <p>and it works perfectly well - I put the result <strong>in the cell I8</strong></p>
  
  <p>but when I copy this function to cell J8</p>
  
  <p>it transfers to:</p>
  
  <pre><code>=SUMPRODUCT(J37:J61, **E37:E61**)
  </code></pre>
  
  <p>I want TO FIX one array, so my function would look like  </p>
  
  <pre><code>=SUMPRODUCT(J37:J61, D37:D61)
  </code></pre>
  
  <p>I hope it's clear what do I want to achieve :)</p>
  
  <p>are there any ways to do so?</p>