Use Pivot Tables... they should do both jobs.

Tutorial: http://peltiertech.com/Excel/Pivots/pivottables.htm