Google Sheets - Query Multiple Columns With Custom Labels

Question

I am trying to create a simple query in my Google Sheet that will allow me to label the two columns it is outputting and sort the results based off of another column. However as soon as I add the Order By or the second Label command it throws and error. Here is my formula. Thanks for any help.

=query(A1:H,"SELECT H, SUM(G) WHERE H > '' AND G > 0 GROUP BY H ORDER BY A LABEL SUM(G) 'Sub Total', LABEL H 'Group Description'",0)

Ed Nelson · Answer 1 · 2017-10-25T13:48:32.533

14

Try this. You can hide the query return of column A if you need to. Also note the label syntax.

=query(A2:H,"SELECT A,H, sum(G) where H is not null and G>0 group by A,H order by A asc label sum(G) 'Sub Total', H 'Group Description',A 'Col A'",1)

Here is my test spreadsheet:https://docs.google.com/spreadsheets/d/1U6OFD_bxkNu27WMFPYHcxps1SA3oH9m3jMTEdb-fiQY/edit?usp=sharing

edited Oct 25 '17 at 13:48

answered Oct 24 '17 at 15:01

Ed Nelson

10,015
2
27
29

Actually I just noticed that putting the sort outside of the query also sorts the headers. – user10012 Oct 24 '17 at 16:06
Change query(A1:H, to query(A2:H – Ed Nelson Oct 24 '17 at 17:35
if I take the headers out completely sort seems to be irrelevant. – user10012 Oct 24 '17 at 17:46
Can you share an example of your data? – Ed Nelson Oct 24 '17 at 20:15

score 0 · Answer 2 · answered Feb 06 '18 at 07:33

You have multiple problems in the query. First, remove the second occurence of LABEL. Secondly the order of columns H and G in the data table (and the query string) should be reversed. The aggregator (coulmn on which you group by) should be on the left.

Google Sheets - Query Multiple Columns With Custom Labels

2 Answers2