QUERY

Definition

A powerful Google Sheets function that lets you run SQL-like queries on spreadsheet data. The syntax is =QUERY(data, query, [headers]). For example, =QUERY(A1:D100, "SELECT A, SUM(D) WHERE B='Marketing' GROUP BY A") returns total spend by date for the marketing category. QUERY is unique to Google Sheets and is one of its most powerful advantages over Excel for data analysis.

Related Templates

These SheetCraft templates use or relate to QUERY:

• Marketing Campaign Dashboard, Track multi-channel marketing campaigns, Google Ads, Meta Ads, email, and organic, with ROAS, CPA, and A/B test logging.
• Small Business Bookkeeping System, Simple bookkeeping for small business owners who don't have an accountant, income, expenses, P&L, sales tax, and bank reconciliation.

Related Terms

• ARRAYFORMULA
• Conditional Formatting
• Data Validation
• IMPORTRANGE
• INDEX-MATCH