title: Countifs with array criteria and multiple ranges
body: <p>I have three columns of Data. <a href="https://i.stack.imgur.com/gpOSy.png" rel="nofollow noreferrer">Image</a></p>
  
  <p>I want to find a permutation where I can count the hits of data that satisfy 3 conditions</p>
  
  <p>1) In column <code>C</code> the data belongs to the group defined as <code>Europe (I9:I12)</code></p>
  
  <p>2) In column <code>D</code> the data belongs to the group defined as <code>Asia (J9:J12)</code></p>
  
  <p>3) In column <code>B</code> the data is greater than year <code>2013 (L9)</code></p>
  
  <p>Basically trying to find the permutation of European countries that cross with Asian countries from <code>2013</code> to <code>2018</code>.</p>
  
  <p>This is my formula as in the image, with Ctrl+Shift+Enter:</p>
  
  <pre><code>{=SUM(COUNTIFS($C:$C,I12:I15,$D:$D,J12:J15,$B:$B,"&gt;="&amp;$L$12))}
  </code></pre>
  
  <p>But gives me 0 at the moment when should find and count 2 results</p>
  
  <p>For interest, my next step would be finding the other way round, cross between <code>Asian</code> and <code>Europe</code>. </p>
  
  <p>I appreciate very much the help</p>