Google SpreadSheet Query: Can I remove column header?

Poliane Brito picture Poliane Brito · Nov 11, 2014 · Viewed 81.5k times · Source

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

KRR picture KRR · Nov 12, 2014

Try this:

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

Hope that Helps!