title: Using SUMIF with INDIRECT
body: <p>Values are in another sheet which is named as cell value"A3"</p>
  
  <pre><code>=SUMIF(INDIRECT(" ' "&amp;A3&amp;" '$B:$B"),D$2,INDIRECT(" ' "&amp;A3&amp;" '!$M:$M"))
  </code></pre>
  
  <p>do you see anything wrong with this formula ?</p>
  
  <p>doesn't work <code>#REF!</code> is the response.</p>