title: google sheet SUM a range by address of the range
body: <p>I have the address of the beginning and end of a range stored in especial cells like below:
  <br>
  <a href="https://i.stack.imgur.com/Y2ur8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Y2ur8.png" alt="enter image description here" /></a></p>
  <p>I want to  use SUM function on this range like this:
  <br></p>
  <pre><code>SUM('P&amp;L'!C3:'P&amp;L'!D3)
  </code></pre>
  <p>I tried the INDIRECT function but I face an error:
  <br></p>
  <pre><code>=SUM(INDIRECT(F2 &amp; &quot;:&quot; &amp; F3))
  
  Function INDIRECT parameter 1 value is ''P&amp;L'!C3:'P&amp;L'!D3'. It is not a valid cell/range reference.
  </code></pre>