You might try using an Excel Pivot Table.

This was a site I found real quick:

http://www.microsoft.com/dynamics/u...es_collins.mspx

You would be surprised what you can do with a Pivot Table.