How to Get Summary Output in Excel

Summarizing your data is the first step to turning raw numbers into real insights, but knowing which Excel feature to use can be tricky. Excel has a huge toolbox for creating summary output, from simple formulas to powerful interactive reports. We'll walk you through the best methods, starting with the basics and moving up to the most flexible tools for the job.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Before You Start: Prepare Your Data for Summarization

No matter which method you choose, your summary will only be as good as your data. Before diving in, take a moment to ensure your data is set up in a simple, tabular format. This means:

• Use Headers: Each column should have a single, unique header in the first row (e.g., 'Date', 'Region', 'Product', 'Sales Amount').
• No Blank Rows or Columns: Keep your dataset as a single, contiguous block of information.
• One Piece of Information Per Cell: Avoid putting multiple values in one cell, like "North, Product A". Give each its own column.
• Consistent Formatting: Make sure your dates are formatted as dates, your numbers as numbers, and your text categories (like "North", "South") are spelled consistently.

A little cleanup upfront saves you a ton of headaches later. Once your data is clean and organized, you're ready to start building summaries.

Method 1: Conditional Formulas (SUMIF, COUNTIF, and SUMIFS)

When you need to answer a single, specific question, conditional formulas are your fastest option. They let you sum, count, or average values based on criteria that you define directly in the formula.

Let's use a sample sales dataset to see how they work:

SUMIF: Totals Based on One Condition

The SUMIF function adds up all numbers in a range of cells that meet one specific criterion. Its structure is:

=SUMIF(range, criteria, [sum_range])

• range: The range of cells you want to evaluate with your criterion (e.g., the 'Region' column).
• criteria: The condition you want to check for (e.g., the text "North").
• sum_range: (Optional) The range containing the numbers you actually want to add up (e.g., the 'Sales Amount' column).

Example: What are the total sales for the North region?

In our sample data, the formula would be:

=SUMIF(B2:B7, "North", C2:C7)

Excel would look down the Region column (B2:B7), find every row with "North," and then add up the corresponding values from the Sales Amount column (C2:C7). The result would be $4,550 ($1,500 + $2,100 + $950).

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

COUNTIF: Counting Based on One Condition

Similarly, COUNTIF counts the number of cells that meet a certain condition. This is great for figuring out "how many" of something exist in your data.

=COUNTIF(range, criteria)

Example: How many orders came from the North region?

=COUNTIF(B2:B7, "North")

This formula counts the occurrences of "North" in the 'Region' column, returning a result of 3.

SUMIFS: Summarizing with Multiple Conditions

What if you need to be more specific? That's where SUMIFS comes in. It lets you sum values based on multiple criteria from different columns. (Note the 'S' at the end). The structure is a bit different, with the sum range coming first:

=SUMIFS(sum_range, criteria_range1, criteria1, criteria_range2, criteria2, ...)

Example: What are the total sales of "Product A" specifically in the "North" region?

=SUMIFS(C2:C7, A2:A7, "Product A", B2:B7, "North")

This formula looks for rows where the product is "Product A" and the region is "North," then sums the sales. In this case, only the first row matches, so the result is $1,500.

Best for: Quick, targeted summaries where you have a specific, unchanging question to answer.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Method 2: The Subtotal Feature

The Subtotal feature is a built-in tool that automatically inserts summary rows into your dataset. It's a fast way to get a bird's-eye view, breaking down your numbers by category directly within your existing table.

The most important rule for using Subtotals is that you must sort your data first by the column you want to group by.

Here’s how to use it:

1. Sort Your Data: Select your 'Region' column. Go to the Data tab and click the Sort A to Z button. All the 'North' sales will now be grouped together, followed by 'South,' and so on.
2. Apply Subtotals: With your data still selected, go to the Data tab and click the Subtotal button (it's usually in the 'Outline' group on the far right).
3. Configure the Settings: A small dialog box will pop up. Set it up like this:

When you click OK, Excel instantly adds new rows to your sheet. You'll see a "North Total," a "South Total," and a "West Total," plus a "Grand Total" at the very bottom. On the left side of your screen, you’ll also notice new outline controls (+, -, 1, 2, 3) that let you collapse or expand the data to see just the summaries or all the detail.

Best for: Creating a quick, hierarchical summary that you can easily print or view as an outline. It’s great for seeing category totals and the underlying detail in one place.

Downside: It physically rearranges your data table by inserting rows, which can make a mess if you need to do further analysis. To remove them, just go back to the Subtotal dialog and click "Remove All."

Method 3: The Power of PivotTables

When it comes to summarizing data in Excel, PivotTables are the undisputed champion. They are an incredibly powerful and flexible analysis tool that lets you summarize huge datasets with just a few clicks - no formulas required.

A PivotTable creates a brand new, separate summary report without altering your original data. You can slice, dice, and rearrange your data on the fly by dragging and dropping fields.

Creating Your First PivotTable

1. Click any single cell inside your organized data table.
2. Go to the Insert tab on the Ribbon and click PivotTable.
3. Excel will automatically select your data range and suggest putting the PivotTable in a new worksheet. Just click OK.

You’ll now see a blank PivotTable on a new sheet and the PivotTable Fields pane on the right. This pane lists all your column headers and has four key areas at the bottom:

• Rows: Fields you drag here will become the row labels of your summary table (e.g., 'Region').
• Columns: Fields you drag here will become the column labels (e.g., 'Product').
• Values: This is where you put the numbers you want to calculate. Excel usually defaults to 'Sum' (e.g., 'Sales Amount'). This is the heart of your summary.
• Filters: Fields here let you filter the entire report by a specific category (e.g., 'Order Date').

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Building a Summary Report

Let's recreate the summary from our formula examples, but this time using a PivotTable.

1. From the field list, drag 'Region' into the Rows area. Your PivotTable will instantly show a unique, alphabetized list of regions.
2. Next, drag 'Sales Amount' into the Values area. Excel will automatically calculate the 'Sum of Sales Amount' for each region.

Just like that, you have a clean summary report with your total sales per region. Want to see sales broken down by product as well?

1. Now, drag 'Product' into the Columns area.

Your table instantly transforms into a matrix showing you sales for each product within each region, complete with row and column totals.

Best for: Almost any summary task. PivotTables are ideal for exploring data, comparing categories, and creating dynamic, professional reports that can be easily updated or changed.

Final Thoughts

From lightning-fast formulas like SUMIF for targeted answers to the robust and flexible power of PivotTables, Excel gives you a wide array of tools to generate summary output. Choosing the right one depends entirely on your goal: a quick calculation is perfect for a formula, while data exploration and reporting are best handled with a PivotTable.

While Excel is fantastic, we know that getting all your data into one place for analysis - especially from platforms like Shopify, Google Analytics, Salesforce, or Facebook Ads - is often the most time-consuming part. We’ve spent countless hours manually exporting CSVs and then cleaning them up before the real work could even begin. That's why we created Graphed. It allows you to connect all of your data sources in seconds and simply ask questions in plain English to build real-time dashboards, letting you skip the manual export/import cycle and get straight to the insights.