title: Apply formula to all rows
body: <p>I know you can apply a function/formula by clicking and dragging the bottom right, but I have a certain problem.</p>
  
  <p>My function looks like this</p>
  
  <pre><code>=IF(COUNT(H3:N3)&gt;0;SUMPRODUCT(H2:N2;H3:N3)/SUM(H2:N2);"")
  </code></pre>
  
  <p>I want all the other rows loook exactly the same, except for the COUNT and the second argument of the SUMPRODUCT.</p>
  
  <p>So the next lines should look like this:</p>
  
  <pre><code>=IF(COUNT(H4:N4)&gt;0;SUMPRODUCT(H2:N2;H4:N4)/SUM(H2:N2);"")
  =IF(COUNT(H5:N5)&gt;0;SUMPRODUCT(H2:N2;H5:N5)/SUM(H2:N2);"")
  =IF(COUNT(H6:N6)&gt;0;SUMPRODUCT(H2:N2;H6:N6)/SUM(H2:N2);"")
  ...
  </code></pre>
  
  <p>So my divisor stays the same and the numbers I multiply with as well (H2:N2).</p>
  
  <p>When I drag by the right corner I always get this:</p>
  
  <pre><code>=IF(COUNT(H4:N4);SUMPRODUCT(H3:U3;H4:U4)/SUM(H3:U3);"")
  </code></pre>
  
  <p>Is there any way I can do this without changing each formula for each row?</p>