title: SUMIF of multiple columns with INDIRECT
body: <p>I have a Excel sheet which is used as database, let's call that <code>MyDB</code> in the following Example. The first column <code>A</code> consists of some strings.</p>
  
  <pre><code>A                | B            | C 
  -----------------|--------------|------------------------------------------
  Turnover 2014    | 1            | 2
  Something        | 2            | 0
  Something        |              | 
  Turnover 2014    | 3            | 1
  Something        |              | 
  Something        | 0            | 2
  </code></pre>
  
  <p>What I want to do is look for the string <code>Turnover 2014</code> and sum all values in that row from B:C (C is just an example in my case it will be variable and can be F or M).</p>
  
  <p><strong>What I have:</strong></p>
  
  <pre><code>=SUMIF(INDIRECT("'MyDB'!A"&amp;Helper!D2&amp;":"&amp;"A"&amp;Helper!D8),"=Turnover 2014",INDIRECT("'MyDB'!$B"&amp;Helper!D2&amp;":"&amp;"B"&amp;Helper!D8))
  </code></pre>
  
  <p>The <code>Helper!D2</code> and <code>Helper!D8</code> contain the variable range, which is one of the reasons I have to use <code>INDIRECT</code>. For this example lets assume <code>D2 = 1</code> and <code>D8 = 6</code> (the full table)</p>
  
  <p>Simple version:</p>
  
  <pre><code>=SUMIF(INDIRECT("'MyDB'!A1:A6"),"=Turnover 2014",INDIRECT("'MyDB'!B1:B6"))
  </code></pre>
  
  <p>This sums all values in <code>B</code> where <code>A = Turnover 2014</code>, so no problem here. Now I will show you my attempts to do the same with multi-columns:</p>
  
  <pre><code>=SUMIF(INDIRECT("'MyDB'!A1:A6"),"=Turnover 2014",INDIRECT("'MyDB'!B1:C6"))
  
  =SUMPRODUCT((INDIRECT("'MyDB'!A1:A6") = "Turnover 2014")*(INDIRECT("'MyDB'!B1:C6")))
  </code></pre>
  
  <p>Both didn't work in my case (IMPORTANT I'm not talking about the simplified version I'm talking about the original version with all the variables). </p>
  
  <p>In all cases I only get the sum of <code>4</code> where I need <code>7</code></p>