title: Using sum within google spreadsheet query results in the word "sum" in many cells
body: <p>I am trying to get the some of all values in row B that contain a certain value in row A. Pretty simple problem I guess.</p>
  
  <p>Here is my query: </p>
  
  <pre><code>=QUERY('Sheet1'!$A$16:D, "Select sum(D) Where C contains '"&amp;C5&amp;"' ", -1)
  </code></pre>
  
  <p>But what that gives me is the actual word "sum" in all the fields where C contains the value.
  So I get a lot of "sum" in almost all my rows.
  Did the "sum" statement change for queries in google spreadsheets?</p>