Google SpreadSheet Query: Can I remove column header?
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?
Solution 1:
Try this:
=QUERY(H4:L35,"select sum(L) where H='First Week' label sum(L) ''")
Hope that Helps!
Solution 2:
=QUERY(QUERY(A1:D, "SELECT *", 1), "SELECT * OFFSET 1", 0)
The outer query: "SELECT * OFFSET 1"
excludes the first row (the header).
The inner query explicitly specifies one row of headers (via the third argument supplied to QUERY
), whilst the outer query specifies none.