Sorting and Grouping in QUERY

Filtering shows you the right rows, but real reports need order and totals. QUERY handles both with two more SQL-style clauses: ORDER BY and GROUP BY.

With these you can answer questions like which region sells the most or list deals from biggest to smallest, all in one formula.

The ORDER BY clause sorts your results by one or more columns. It goes after WHERE (if present).

By default it sorts ascending (smallest first, A to Z). This formula lists every row sorted by sales from low to high.