title: Using an Array Function with TEXTJOIN to concatenate multiple cells, but with multiple criteria?
body: <p>I have found that the following formula works perfectly, as long as I only use one criteria.</p>
  
  <pre><code>{=TEXTJOIN("; ", 1, IF(A2:A9="USA", C2:C9, ""))}
  
  Result: "Apples; Crust; Flour; Chocolate"
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/1PBoS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/1PBoS.png" alt="enter image description here"></a></p>
  
  <p>But, how do I add multiple criteria. For example, I've tried the following:</p>
  
  <pre><code>{=TEXTJOIN("; ", 1, IF(AND(A2:A9="USA", B2:B9="Cake"), C2:C9, ""))}
  
  Desired Result: "Flour; Chocolate"
  </code></pre>
  
  <p>But, this formula pulls up no matches. Is there a way to get 2+ criteria to work with this Array TEXTJOIN function?</p>