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:
How can I remove the header?
Asked
Active
Viewed 2,363 times
-1
tehhowch
- 9,645
- 4
- 24
- 42
Alexander North
- 11
- 2
-
3Possible duplicate of [Google SpreadSheet Query: Can I remove column header?](https://stackoverflow.com/questions/26867775/google-spreadsheet-query-can-i-remove-column-header) – Max Makhrov Aug 22 '18 at 12:25
1 Answers
1
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) ''
Max Makhrov
- 17,309
- 5
- 55
- 81
-
Thx! Oh wow, i add to the end same things, but without space - label SUM(J)/SUM(I)'' and its not working. – Alexander North Aug 22 '18 at 12:52