title: OR logic and CONTAINS in a query in Google Sheets
body: <p>I have a problem with an OR logic in a query. I'm trying to make a sum of a column (D), if:</p>
  
  <p>• column A = <code>cars/build-price/carselector.html</code></p>
  
  <p>• column B = contains <code>ateca</code> or <code>ibiza</code> (the cell could be "get the ateca", "new ibiza xx", ...)</p>
  
  <p>• column C = <code>footer</code></p>
  
  <p>First tried with a SUMIFS but didn't work:</p>
  
  <pre><code>=SUMIFS(C:C;A:A;"cars/build-price/carselector.html";B:B;{"ateca"; "ibiza"};D:D;"footer")
  </code></pre>
  
  <p>then tried with a QUERY, but I don't really know this language:</p>
  
  <pre><code>=SUM(QUERY(A:D;"Select C where A='cars/build-price/carselector.html' and D='footer' and (B='ateca' or B='ibiza')"))
  </code></pre>
  
  <p>Can't find how to fit the "contains" and the "or" logic.</p>
  
  <p>Someone can help?</p>