QUERY pitfall 1: Column references inside the query string use letters (SELECT A, B), even if your range starts mid-sheet?

Column references inside the query string use letters (`SELECT A, B`), even if your range starts mid-sheet.

QUERY pitfall 2: Mixed types in a column (numbers stored as text) cause silent failures?

Mixed types in a column (numbers stored as text) cause silent failures. Force types with `Col1 + 0` or `TO_TEXT()`.

The optional 3rd arg `headers` controls how many header rows to skip. Pass `1` if your range starts at row 1 with headers.

Arrayhard

Runs a Google Visualization API Query Language query across data.

Syntax

=QUERY(data, query, [headers])

Example

=QUERY(A1:D, "SELECT B, SUM(D) GROUP BY B")

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and QUERY isn't one of them yet.

Column references inside the query string use letters (SELECT A, B), even if your range starts mid-sheet.
Mixed types in a column (numbers stored as text) cause silent failures. Force types with Col1 + 0 or TO_TEXT().
The optional 3rd arg headers controls how many header rows to skip. Pass 1 if your range starts at row 1 with headers.

Related formulas

Used by