If you have them all in excel I assume you have a Category Column? Did you sort by the Category column? Then add a couple rows between the Categories and enter a sum for each category.
