content_image/714396.jpg content_image/714397.jpg content_image/714398.jpg content_image/714399.jpg
<img src='content_image/714396.jpg'>

Other functions include: averaging the numbers in a column, counting the numbers in a column and finding the minimum and/or maximum numbers in the column. 

Additionally, there is an AutoSum  button and dropdown menu also located on the Home toolbar. 

<img src='content_image/714397.jpg'>

## Subtotaling 

The Subtotal tool is used sum data by group. Subtotaling data eliminates the need to manually insert a row and perform a summation. 

Below is a sample data sheet for which we need to calculate the total amount paid for each semester. 

<img src='content_image/714398.jpg'>

## One Level Subtotals 

To Subtotal a data sheet: 

1. Select the Subtotal  button located on the Data toolbar. 

<img src='content_image/714399.jpg'>

The Subtotal dialogue box will open 

