2

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.