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
- 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.
- 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.
- 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.
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.
- How to Summarize a List of Names in Excel
- How to Group and Summarize Data in Excel
- How to Create a Summary Sheet in Excel
- How to Make Summary in Excel From Different Sheets
- How to Summarize Text Data in Excel
- How to Summarize Data by Multiple Columns in Excel
- How to Summarize Data Without Pivot Table in Excel