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

Rafsun Royal
Rafsun Royal ✭✭✭✭
edited 12/09/19 in Smartsheet Basics


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

Screen Shot 2019-04-15 at 10.19.39 AM.png