Google Sheets questions cookbook
The business questions owners and managers ask of a spreadsheet, each answered two ways: the classic formula, written properly, and a single =QUIRIZ cell. Both worked on the same sample data, with the real numbers they return.
Every page follows the same recipe: the sample data, the formula that answers the question (QUERY, SUMIFS, COUNTUNIQUEIFS or a pivot table), the gotchas that make it quietly wrong, and the one-cell =QUIRIZ version. The example numbers are computed from the sample files below, so you can import them and check every figure.
Sales
How to Make a Monthly Sales Report in Google Sheets
Revenue and order count for each of the last twelve months, rolling.
SalesHow to Show Sales by Region and Channel in Google Sheets
Regions down, channels across, totals on both edges.
SalesHow to Calculate Month-over-Month Growth in Google Sheets
This month vs last month, in dollars and percent.
SalesHow to Compare Sales Year over Year in Google Sheets
Each month this year beside the same month last year.
Customers
How to Find Your Top Customers by Revenue in Google Sheets
Total each customer, sort biggest first, keep ten: one QUERY formula.
CustomersHow to Calculate Average Order Value by Month in Google Sheets
Revenue over distinct orders, and why AVERAGE() gets it wrong.
CustomersHow to Count New vs Returning Customers in Google Sheets
First-time buyers vs regulars each month, and the regulars' share of revenue.
Products
How to Show Sales by Product Category in Google Sheets
Revenue per category and its share of the total.
ProductsHow to Find Your Best-Selling Products in Google Sheets
Top products by units, with revenue beside them.
ProductsHow to Calculate Gross Margin by Product in Google Sheets
Revenue, cost, gross profit and margin for every product.
Sales pipeline
Finance
How to Track Expenses by Category by Month in Google Sheets
Categories down, months across, one SUMIFS for the whole grid.
FinanceHow to Build a Budget vs Actual Report in Google Sheets
Budget and actual side by side, with the variance in dollars and percent.
FinanceHow to Build an Accounts Receivable Aging Report in Google Sheets
Unpaid invoices in current, 30, 60, 90 and 90+ day buckets.
The sample data
A fictional specialty-coffee wholesaler selling beans, tea, café supplies and equipment to 95 cafés, bakeries, restaurants, grocers and offices. All names are made up. Download a file and import it into Google Sheets (File → Import) to follow any page:
orders.csv: 8,120 order lines from January 2025 to October 2026deals.csv: 240 deals in a sales pipeline, as of October 31, 2026expenses.csv: 207 operating expenses from January to October 2026budget.csv: 96 monthly budget lines for 2026invoices.csv: 2,094 invoices issued in 2026 on Net 30 terms, as of October 31, 2026
Ask the question, get the table
Quiriz answers business questions in a Google Sheets cell, from your imported files, scheduled Google Sheets and connected tools. Free to start.
Install for Google Sheets →Free on the Google Workspace Marketplace. Or try it on sample data first, no signup.