content_image/665863.jpg content_image/665864.jpg
## Nested Level Subtotals 

Nested Level Subtotals are used to subtotal more than one level of data. 

For this example our list of data contains individual payers and semesters 

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

1. Select any cell within your range of data 

2. Select Subtotal  on the Data tab. 

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

The Subtotal dialogue box will open. 

3. For the At Each Change  in dropdown menu, select Semester . 

4. Choose to Use Function , Sum . 

5. Choose to Add Subtotal To , Amount Paid . 

