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

Get FREE Advanced Excel Exercises with Solutions!

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.

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.

## What is ExcelDemy?

ExcelDemy Learn Excel & Excel Solutions Center provides free Excel tutorials, free support , online Excel training and Excel consultancy services for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Al Ikram Amit

Hello, I'm Amit, a BUET graduate with a passion for Excel. Currently, I work as an Excel & VBA Content Developer at ExcelDemy, contributing insightful articles to the blog. I enjoy sharing my knowledge with others and always look for opportunities to grow as an Excel expert. Feel free to reach out if you need assistance or want to discuss the latest trends in Excel. Let's excel together in the world of data manipulation and analysis!

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

• Hello, Suzette!

Thanks for your appreciation. We will try to use fonts that will be easier to read for old eyes.

Regards
ExcelDemy

Advanced Excel Exercises with Solutions PDF