How to get the sum only for a Specific Dropdown Value Selected

Hi,

I want to get the sum for only the dropdown value selected:

Here is the Situation:

First Column: I have 3 Resource Type:

1. Offshore

2. Onshore

3. Remote

Column 2: I have resource Name

Column 03 to 35  is a Hour Cloumn ( Where it shows how mnay hours each of my resource is available to work)

Now I need to calculate:

1.  How many totals hours I have for each of my resource (daily, weekly and Monthly)

2. How many total hours I have for each of the resource type mentioned above (daily, weekly and Monthly)

Please help! I know we can use children function but I can't do it now!!!!! Please see the attached screenshot