In this tutorial, you will learn how to create a summary table in Excel.
To transmit the most information as simply as feasible, summary statistics are used in descriptive statistics to summarise a group of data.
Once you are ready, we can get started by using real-life scenarios to help you understand how to create a summary table in Excel.
Table of Contents
Create a Summary Table
Before we begin we will need a group of data to be used to create a summary table in Excel.
Step 1
Make sure your group of data is displayed in a clean and tidy manner in the first sheet.
Step 2
In this example, we will create a summary table to show the average height, weight and total donation for each student. To do so, we will use this formula to calculate the average height for each student =AVERAGEIF($A$2:$A$13, F3, $B$2:$B$13). To calculate the average weight for each student =AVERAGEIF($A$2:$A$13, F3, $C$2:$C$13). To calculate the total donations for each student =SUMIF($A$2:$A$13, F3, $D$2:$D$13).
Step 3
Your summary table will look like this.
