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! 
Please see the attached screenshot
Comments
-
Hello,
The easiest would be to get the totals by:
-adding a Weekly/Monthly Total Hours column to the sheet (can be hidden and used only for calculation purposes)
-using SUMIF function on the Dash part of the sheet to get the total hours by resource
-setting up a report
-
I am going to suggest a few helper rows (3 to 4 of them will work depending on your needs).
You can set them up in any order that is most comfortable for you. The below is simply an example.
Row 1: Day
Row 2: Month
Row 3: Year
Row 4: Week number (1 - 52)
.
These can all be automated or the numbers can be manually added. From there, you will be able to use a SUMIFS statement and pull column totals based on what is in the helper rows depending on what exactly you are looking for.
