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?
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) ''