title: Drag down formula without changing the value of row 1?
body: <p>I have a formula to calculate the total score of a review:</p>
  
  <pre><code>SUM(B1*B3,C1*C3,D1*D3,E1*E3)
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/UAT2n.png" rel="nofollow noreferrer">Excel Doc</a></p>
  
  <p>is there a way to to drag the formula down from the total column without changing the value of B1, C1, D1, and E1?</p>
  
  <p>Right now when I drag I get this:</p>
  
  <ul>
  <li><p>Instance 2 </p>
  
  <p><code>=SUM(B2*B4,C2*C4,D2*D4,E2*E4)</code></p></li>
  <li><p>Instance 3   </p>
  
  <p><code>=SUM(B3*B5,C3*C5,D3*D5,E3*E5)</code></p></li>
  </ul>
  
  <p>What it should do instead when drag is this:</p>
  
  <ul>
  <li><p>Instance 2</p>
  
  <p><code>=SUM(B1*B4,C1*C4,D1*D4,E1*E4)</code></p></li>
  <li><p>Instance 3 </p>
  
  <p><code>=SUM(B1*B5,C1*C5,D1*D5,E1*E5)</code></p></li>
  </ul>
  
  <p>I'll be glad for any help thanks</p>