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
Comments
-
What do you mean you can't do the children function now? it should just be a sumif. Is this parsed out onto 2 separate sheets currently?
-
@L@123,Β I have tried with Children function but for some reason it's showing incorrect formula.
-
The resources are not children of row 5 though - that's why the Children function won't work. As @L@123 mention - sum if is the way to go with this problem, see below.
Β
-
Hi Rafsun,
You can use the CHILDREN function if referenceΒ row 9.
Would that work?
Have a fantastic week!
Best,
AndrΓ©e StarΓ₯
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
A BIG thanks to you Sean for your help!!!
I have applied those and it worked but it's just giving me the sum by per day. Any idea how can I select the range for a week, meaning my week 1 (ranging from 4/15 to 4/19). I need sum of the weekly hours for a particular resource type.Again thanks for your time.
Have a great week!
-
Thanks Andree! It worked!
Have a great week! -
Excellent!
Happy to help!
Best,
AndrΓ©e
SMARTSHEET EXPERT CONSULTANT & PARTNER
AndrΓ©e StarΓ₯ | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 205 Use Cases
- 516 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives