This might helpyou get started

http://excel-it.com/pivot_tables.htm

Post back if you need further help, some dummy data in a workbook would be useful