Sales, Customer, Product & Region Analysis in Excel: One Table, Four Business Questions

One sales table can answer dozens of different business questions. Slice it by product, by customer, or by region and you get a different insight each time. This tutorial shows how Copilot inside Excel and ChatGPT outside it, plus a few formulas, analyze performance across these four dimensions.

Table of Contents

• Four Dimensions, One Table
• Sales Analysis: the overall picture
• Product Analysis: which products earn their place
• Customer Analysis: who drives revenue
• Region Analysis: where business happens
• PivotTables: slice everything at once
• Best Practices

Four Dimensions, One Table

A dimension is a way to slice your data. The Sales table (Order ID in A, Date in B, Region in C, Product in D, Customer in E, Units in F, Sales in G, rows 2–16) holds all the details. Each analysis below asks the same underlying question — "how is performance split by...?" — against a different column. The formulas are near-identical, which is the point: learn one and you've learned the pattern.

Sales Analysis: the overall picture

Sales analysis looks at the whole business before slicing it: total revenue, number of orders, average order value, and how sales are moving.

Ask Copilot in Excel:

What were total sales, how many orders did we have, and what was the average order value?

Prefer to work outside Excel? Paste the table (or the Sales and Customer columns) into ChatGPT and ask the same question — it returns the totals and explains the average order value in plain words. Both paths give the same answer; Copilot keeps it inside the workbook.

The formulas behind the answer:

=SUM(G2:G16)
=COUNTA(E2:E16)
=SUM(G2:G16)/COUNTA(E2:E16)

The first formula adds up all revenue. The second counts the customer names in column E — one per order — so it gives the number of orders. (Use COUNTA, not COUNT: customer names are text, and COUNT only counts numbers.) The third divides revenue by order count — the typical amount a customer spends per order, about $942 here. Track it over time: it's a core KPI you'll revisit in Tutorial 4.

Product Analysis: which products earn their place

Product analysis ranks each product by revenue, units, or profit to find the stars and the drains.

Ask Copilot in Excel:

Break down sales and units by product, sorted from highest to lowest.

Or paste the Product and Sales columns into ChatGPT with "Rank these products by sales, highest first, and tell me which is the weakest."

The formula version uses SUMIFS to total sales for one product.

Syntax: =SUMIFS(sum_range, criteria_range, criteria, ...)

=SUMIFS(G2:G16, D2:D16, "Laptop")
=SUMIFS(G2:G16, D2:D16, "Monitor")

SUMIFS sums column G (sales) for every row where column D (product) matches the name. Compare the results across products to spot the best seller and the weakest one. You can sum Units instead of Sales to rank by volume, which often tells a different story than revenue.

Customer Analysis: who drives revenue

Customer analysis reveals which customers matter most — and who might deserve a discount, a follow-up, or extra attention.

Ask Copilot in Excel:

Show total sales by customer, sorted highest to lowest.

Or paste the Customer and Sales columns into ChatGPT and ask "Who are my top 3 customers by revenue, and what share of total sales do they make up?"

The formula version:

=SUMIFS(G2:G16, E2:E16, "Acme Inc")
=SUMIFS(G2:G16, E2:E16, "Beta LLC")

Same pattern, different criteria column. Compare the customer totals: if one customer is a large share of revenue, they're valuable but also a risk — losing them hurts.

Note: A fuller customer analysis uses RFM — Recency (when did they last buy), Frequency (how often), and Monetary (how much). Even with just frequency and monetary value you can split customers into "best", "regular", and "at risk" groups.

Region Analysis: where business happens

Region analysis shows where sales come from and whether any region is underperforming.

Ask Copilot in Excel:

Compare total sales by region as a chart.

Or paste the Region and Sales columns into ChatGPT and ask "Which region sells the most, and what percentage of total sales does it represent?"

The formula version:

=SUMIFS(G2:G16, C2:C16, "North")
=SUMIFS(G2:G16, C2:C16, "South")

Which region contributes the most? Which the least? Dig into the weakest region's products or customers — the cause is often visible once you combine dimensions (e.g., "South" sells well for Laptops but not Monitors).

PivotTables: slice everything at once

A PivotTable is the manual, no-typing version of all the SUMIFS above. It takes seconds to build and lets you switch dimensions without rewriting formulas.

1. Click any cell in the Sales table
2. Insert → PivotTable → OK
3. Drag "Product" into Rows
4. Drag "Sales" into Values (it sums automatically)
5. Drag "Region" into Columns to cross two dimensions at once

Drag Product and Sales in, and you have the product ranking from earlier. Add Region as a column and you see products × regions in one grid. This is also what Copilot generates behind the scenes when you ask it to "summarize by product" — the PivotTable just makes it visible and editable. Stuck building one? Paste your column layout into ChatGPT and ask "What fields do I drag where to get sales by product and region?"

Best Practices

• Keep one clean master table and build all analyses from it. Don't create a separate sheet per question.
• When comparing regions or products, look at relative shares (%) as well as absolute totals — a big region naturally sells more.
• Use SUMIFS over SUMIF even when you only need one filter; the extra S costs nothing and gives you more power later.