content_image/677195.jpg content_image/677196.jpg
<img src='content_image/677195.jpg'>

To subtotal this data sheet by semester: 

1. Choose Semester  for the At Each Change  In dropdown. 

2. Select Sum  for the Use Function  dropdown. 

3. Choose Amount Paid  for the  Add Subtotal To  field. 

4. Click Ok . 

Subtotals will automatically be added to your data. 

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

The subtotal hierarchy located to the left of the spreadsheet can be used to hide some of the data within the spreadsheet. 

To view only the grand total, select column 1 

To view the total for each subsection, select column 2 

To view all data, select column 3. 

