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

Rafsun Royal

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

 

Viktoria B.

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

Paul Newcome

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.