Excel has great tools to total and subtotal your data. One nice option is the ability to add several subtotals to a data range. Take a look at the video below and see how easy this can be:
You can download the file here and follow along. If you get a preview, look for the download arrow in the upper right hand corner.