title: sumifs reference to different worksheets in one workbook
body: <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>