Google SpreadSheet Query: Can I remove column head

Question

I'm doing this query at my google spreadsheet:

=QUERY(H4:L35;"select sum(L) where H='First Week'"; -1)

But it returns a little table with "sum" as header and result below it. What I want is just the result! How I remove header? Can I?

Answer 1

=QUERY(QUERY('Form responses 3'!$A$2:$P$1017,"SELECT max(E),max(C), max(D) WHERE B='" & B14 & "' GROUP BY B LIMIT 1 ",-1),"SELECT * offset 1",0)

Second Query: "SELECT * offset 1" Exclude 1st header

Answer 2

See the format here.

Example:

=QUERY(B4:C38,
   "SELECT C, sum(B) where C!='' group by C label C 'Member', sum(B) 'Sum'"
)

Answer 3

Try this:

=QUERY(H4:L35,"select sum(L) where H='First Week' label sum(L) ''")

Hope that Helps!