Adding subtotal is a useful feature in Excel 2010. It is easy to do as well,
Steps to add subtotal in Excel
- Raw data should have some common relationship, such as date and category in sample data below.
- Sort data on the category for subtotal with Sort command in Data tab
- Go to data tab, Outline group and click on Subtotal.
- Final Data