Column total when Matching 1st Column

If you don't want the subtotals interspersed with the data, you could use a pivot table. You need to give the columns headers. Then the first column would go in the row area, and the next two would go in the Data Area.

Here are detailed directions (for Excel 2003)

1. Choose Data->Pivot Table and and Pivot Chart Report from the main menu
2. Where is the Data? (Microsoft Office Excel List)
3. What kind of report? (Pivot Table)
4. Next
5. Where is the Data: Range? (Highlight the data including the header)
6. Next
7. Where do you want it (Choose what you want)
8. Finish
9. Drag the column A header to the Row Area
10. Drag the column B and C headers to the Data Area

It will automatically sum them and group them by the value in the first column. Another advantage is that it doesn't need to be sorted by the first column -- it will group them even if the matches are not right next to each other.