How to group and sum the data for each resource from daily to weekly

I have a spread sheet containing below columns.

1. Date 2. No hours logged 3. Week number 4. Resource name

I am trying sum the number of hours logged for each resource in a particular week.

Following is the sample data

Date Logged HourWeek Num Resource
1/13/12 0.5 2 X
1/16/12 1 3 y
1/19/12 6 3 y
1/19/12 6 3 y
1/20/12 8 3 y
1/20/12 8 3 m
1/25/12 0.75 4 l
1/27/12 0.5 4 l
2/2/12 0.5 5 r
2/1/12 4 5 a
2/3/12 4 5 J
2/3/12 2 5 J
2/6/12 0.75 6 L
2/6/12 6 6 L

The end result should contain one row (remaining can be blank ) with Resource name, Week number and total hours logged in that week.

Can you please help me in getting the right formula to get sum the hours for each resource.

Thanks
Eswar

I added sample data and please let me know if you need any other details

Thanks
eswar

Maybe with a pivot table (see example).

Thanks for the help in getting the results using Pivot table.

If your problem is solved, please mark it as solved.

Otherwise we see your further questions.