Type =QUERY(range, "select ... where ...", 1) to filter, sort, and total data in one formula. This guide explains the syntax, clause order, text, number and date conditions, GROUP BY and PIVOT, cell references, Col1 notation, IMPORTRANGE, and how to fix common…