# 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.

## 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.

• 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.

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.

• Now, we have to remove the repeatedly selected cells from â€˜Remove Duplicateâ€™ under the Data tab.

• After that, this pop-up will appear and we will select â€˜Continue with the current selectionâ€™ and click the â€˜Remove Duplicatesâ€¦â€™.

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

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

• 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.

## 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.

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

• 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.

• 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.

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

• Now select a suitable option from the list.

## Conclusion

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, 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