Excel Tutorial: Subtotal
Let's check this out.
Step: 1
Before insert Subtotal, you need to sort the list so that the rows you want to subtotal are group together.
Step: 2
On the Data tab, in the Outline group, click on the Subtotal.
Step: 3
Now, in each change in box, click the column that contains the group for which you want subtotal, then click OK.
Step: 4
Check your result now.