37  The Subtotal dialogue box will open  To Subtotal a data sheet:  Below is a sample data sheet for which we need to calculate the total amount paid for each semester.  The Subtotal tool is used sum data by group. Subtotaling data eliminates the need to manually insert a  row and perform a summation. Additionally, there is an  AutoSum  button and dropdown menu also located on the Home toolbar. 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. Subtotaling  One Level Subtotals  1. Select the  Subtotal  button located on the Data toolbar.