How to Create a Summary Table in Google Sheets (With Example)


Often you may want to create a summary table in Google Sheets to summarize the values in some dataset.

Fortunately this is easy to do using built-in functions in Google Sheets.

The following step-by-step example shows how to create a summary table in Google Sheets in practice.

Step 1: Enter Values for Dataset

First, we’ll enter the following dataset that contains information about product sales for some company:

Step 2: Find Unique Values

Next, we’ll use the following formula to identify the unique product names in column B:

=UNIQUE(B2:B13)

We can type this formula into cell A17:

We can see that this formula is able to extract the three unique product names from column B.

Step 3: Calculate Summary Statistics for Each Variable

Next, we can calculate the total units sold, average number of units sold, and total revenue for each product by using the following formulas:

Total Units Sold:

=SUMIF($B$2:$B$13, A17, $C$2:$C$13)

Average Number of Units Sold:

=AVERAGEIF($B$2:$B$13, A17, $C$2:$C$13)

Total Revenue:

=SUMIF($B$2:$B$13, A17, $D$2:$D$13)

We can type these formulas into cells B17, C17, and D17, respectively:

We now have a summary table that tells us the total units sold, average units sold, and total revenue for each of the three products from our original dataset.

Step 4: Format the Summary Table (Optional)

Lastly, feel free to add a border around each cell in the summary table and add background colors to make the summary table more aesthetically pleasing:

Google Sheets summary table

The summary table is even easier to read now.

Note: We chose to calculate mean values and sum values in our summary table, but feel free to calculate other values of interest such as the minimum, maximum, median, range, and other metrics.

Additional Resources

The following tutorials explain how to perform other common tasks in  Google Sheets:

How to Calculate a Five Number Summary in Google Sheets
How to Calculate Average by Group in Google Sheets
How to Use SUMIF Contains in Google Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *