title: Google sheets Query WHERE only returns first row
body: <p>I am trying to query data from a sheet matching two conditions. However, when there is more than 1 row in the data matching my condition the query only returns the first result. How do I make sure it returns ALL rows matching the conditions?</p>
  
  <p>I tried changing the single and double quotes, capital letters, changing the format of the data but nothing worked.</p>
  
  <p>The query:</p>
  
  <pre><code>query(Raw!A1:J29041, "select B,C,D,E, sum(F) where B='"&amp;sheet1!A2&amp;"' and E='good source' and not C='2016' GROUP BY B,C,D,E")
  </code></pre>
  
  <p>Example of data:</p>
  
  <pre><code>Client     Year    Month    Source         Count
  Client a    2019    July    other source    1
  Client a    2019    July    good source     2
  Client a    2019    July    bad source      22
  Client a    2019    July    good source     63
  Client a    2019    July    another source  1
  Client a    2019    July    another source  8
  </code></pre>
  
  <p>Desired output for this data:</p>
  
  <pre><code>Client      Year    Month   Source          sum
  Client a    2019    July    other source    65
  </code></pre>