# How to Create a Summary Table in Excel

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.

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