Adding subtotal is a useful feature in Excel 2010. It is easy to do as well,

Steps to add subtotal in Excel

  1. Raw data should have some common relationship, such as date and category in sample data below.
    001 - Excel Data
  2. Sort data  on the category for subtotal with Sort command in Data tab002 - Sort Data
  3. Go to data tab, Outline group and click on Subtotal. 003 - Subtotal
  4. Final Data004 - Data with Subtotal