sumifs reference to different worksheets in one workbook
<p>in the pictures above i made a simplified example of the problem</p>

<p>so the formula that produces the 11 </p>

<pre><code>=SUMIFS(Sheet1!B2:B30,Sheet1!A2:A30,"&gt;="&amp;B3,Sheet1!A2:A30,"&lt;="&amp;C3)
</code></pre>

<p>but lets say i want to put the formula in sheet 3 how would i adapt the 
<code>"&gt;="&amp;B3,Sheet1!A2:A30,"&lt;="&amp;C3)</code> part
<img src="https://i.stack.imgur.com/hSJob.jpg" alt="image">
<img src="https://i.stack.imgur.com/wbmRD.jpg" alt="image"></p>