How to Create Summary Table in Excel (3 Easy Methods)

If you want to create a summary table in Excel, you have come to the right site. We have discussed several straightforward methods in this post to create a summary table in Excel. So, continue with us and adhere to the process.

Watch Video – Create Summary Table in Excel

With the data from the most recent epidemic, we attempt to create a summary table in Excel. Given below is a prototype table.

Sample Data: How to Create Summary Table in Excel

1. Using UNIQUE and SUMIFS Functions to Create Summary Table in Excel

Microsoft 365 has quite amazing features like the UNIQUE function. So in this process, we are going to use UNIQUE and SUMIFS functions.

📌 Steps:

  • In the first step, we just use the UNIQUE function and select the whole Continent column. This function will remove repeated items from the column.

Apply UNIQUE Function

  • Now we will use another amazing function SUMIFS in Excel 365. Now in the SUMIFS, we will first select the column that we want to sum up, then the corresponding column, in this case, the Continent column, and then the sorted Continent column shown in the fifth stage in the below image.

Apply SUMIFS Function to Create Table Summary in Excel

Read More: How to Summarize Subtotals in Excel

2. Building a Simple Summary Table Using SUMIF Function

Without having Excel from Microsoft 365, we will go through the manual process shown in the below images.

📌 Steps:

  • First of all, we will copy the Continent column and paste it into the first column of our summary table.

Copy Continent Column and Paste to Another Place

  • Now, we have to remove the repeatedly selected cells from ‘Remove Duplicate’ under the Data tab.

Remove Duplicate

  • After that, this pop-up will appear and we will select ‘Continue with the current selection’ and click the ‘Remove Duplicates…’.

Remove Duplicate with Current Selection

  • Following that, this box will appear and we will hit the OK button.

Continent Column

  • Subsequently how many duplicated items have been removed will appear in the message box. We will just click the OK button.

Number of Duplicate Items Removed Popup

  • So, our final step is to use the SUMIF function, for that case we will type SUMIF in the formula box and select the Continent as ‘range’, the Continent column in the summary table as ‘criteria’, and lastly ‘sum range’ will be the Daily Deaths column.

SUMIF Function to Create Summary Table in Excel

3. Using Excel Pivot Table to Create Summary Table

To summarize a table, pivoting is the most popular approach. And we will start with the Pivot Table.

📌 Steps: 

  • So firstly we will select the table and from the Insert tab, we will select Pivot Table.

Insert Pivot Table

  • This pop-up will appear and without any change just hit OK.

Pivot Table Range

  • As we have chosen in the previous box the PivotTable to be placed in the New Worksheet, the below worksheet will appear in your WorkBook.

Pivot Table in New Sheet

  • In this case, we have selected ‘Continent’ and ‘Total Vaccination’, and then like in ‘3’ shown in the image we will select ‘sum of Total Vaccination’. We can also select other options to get an overview of the total dataset.

Summary Table in Excel Using Pivot Table

  • If you don’t see the Sum option in the Pivot Table Value section, then click on the following drop-down.

Sum Up Required Column

  • Now select a suitable option from the list.

Select Sum and Click OK

Read More: How to Create Summary Table from Multiple Worksheets in Excel

Download Practice Workbook

You can download the practice workbook from the following download button.


I hope these techniques will make your tasks or projects easier. You may also download the workbook and use it for your own practice if you want to master this subject. If you have any questions, problems, or recommendations, just let me know in the comment area.

Related Articles

<< Go Back to Summarize Data In Excel | Data Analysis with Excel Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Al Ikram Amit
Al Ikram Amit

Al Ikram Amit, holding a BSc in Naval Architecture & Engineering from Bangladesh University of Engineering and Technology, serves as a key Excel & VBA Content Developer at ExcelDemy. Driven by a profound passion for research and innovation, he actively immerses himself in Excel. In his role, Amit not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently delivering exceptional, high-quality content that adds significant... Read Full Bio

  1. Your information is REALLY helpful BUT please edit the fonts. Those outlined letters are really hard for old eyes.

Leave a reply

Advanced Excel Exercises with Solutions PDF