title: SUMIFS returning ZERO
body: <p>I'm running some tests in this worksheet and for some reason that I don't know, SUMIFS is not working:</p>
  
  <p><code>=SUMIFS($AC:$AC,$AB:$AB,$BA$1 &amp; "-" &amp; BB$1 &amp; "-" &amp; $BA3,$AB:$AB,$BA$1 &amp; "-" &amp; BB$1 &amp; "-" &amp; $BA4)</code></p>
  
  <p><img src="https://imgur.com/9Z2fjEa.jpeg" alt="formula view"></p>
  
  <p>I just don't get why it is not working. Just above I used a COUNTIF with similar cell references and it worked:</p>
  
  <p><code>=COUNTIF($AA:$AA,$BA$1 &amp; "-" &amp; BB$1 &amp; "-" &amp; $BA4)</code></p>
  
  <p><img src="https://imgur.com/ToGnHNA.jpeg" alt="formula view"></p>
  
  <p>I also used a SUMIF in a cell below just to test and it also worked:</p>
  
  <p><code>=SUMIF(AB:AB,BA1 &amp; "-" &amp; BB1 &amp; "-" &amp; BA2,AC:AC)</code></p>
  
  <p><img src="https://imgur.com/qXeWJLI.jpeg" alt="formula view"></p>
  
  <p>The values in AA and AB are the same, the only difference is that some cells in AA are merged.</p>
  
  <p>Values in AC are not formatted as text.</p>
  
  <p>I double checked searching for a character misplaced (like a "space") and there is nothing wrong.</p>
  
  <p>Already tried to write the criteria instead of use the cell references and didn't work. Tried also to select one of the cells of AB as criteria and didn't work. The result is always 0.</p>
  
  <p>I just can't find where I'm messing up. Could someone please enlighten me?</p>