title: How to ignore or copy a part of formula in EXCEL from one column to another?
body: <p><img src="https://i.stack.imgur.com/nDd2X.jpg" alt="Example image"></p>
  
  <p>I have used formulas in the following way:</p>
  
  <pre><code>N9/SUM(K10:K11),
  N12/SUM(K13:K22),
  N23/SUM(K24:K32),
  </code></pre>
  
  <p>And so on...</p>
  
  <p>I want to copy only <code>SUM(K10:K11)</code> this part of formula from each cell to another cell without changing the cell reference <code>K</code>.</p>
  
  <p>How can I do it?</p>
  
  <p><strong>Example:</strong></p>
  
  <p>Cell <code>C4</code> uses formula <code>=A4/SUM(B5:B8)</code> now I need to copy only <code>SUM(B5:B8)</code> this part of formula to cell <code>D4</code>. </p>