Search code examples
google-sheetsgoogle-sheets-query

QUERY Google Sheet not remove headers


I am using this formula:

=QUERY(gis_sources!$B$2:$L$3008;"SELECT SUM(J)/SUM(I) WHERE (B = 'i.bat' AND MONTH(C) = 7)")

But it gives me this header row:

enter image description here

How can I remove the header?


Solution

  • Add label SUM(J)/SUM(I) '' to the end of the query text to remove the header.

    Add label SUM(J)/SUM(I) 'your name' to remove add your name as the header.

    The text of query:

    "SELECT SUM(J)/SUM(I) WHERE (B = 'i.bat' AND MONTH(C) = 7) label SUM(J)/SUM(I) ''