Data search and corellation

Hello

I have hundreds of pages of data that I am going through for Pie and Pareto analysis and I am trying to speed up the process by using formulas instead of me manually having to filter through it every day.

I have 3 columns ...

A - Date
B - Problem Duration
C - Problem Code (30 codes)

for example
A ----------- B -- C
01/06/13 - 20 - 7
01/06/13 - 10 - 28
01/06/13 - 50 - 1
02/06/13 - 90 - 7
02/06/13 - 15 - 5

And I am tring to use a summary sheet where I can input a date range it it will automatically tell me the number of times a code appeared and the total duration for that inputted date range

For example ....

Range - 01/06/13 to 02/16/13

Code 1 - 50
Code 5 - 15
Code 7 - 110
Code 28 - 10

If anyone could help it would be amazing as it's driving me mad going through the data manually every day!

I'm using Excel 2010


Regards

Carl