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

Find more posts tagged with

Marketing

IT & Operations

Project Management

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Dashboard Adding Widgets Spontaneously
Howdy, I am working on developing a several dashboards for our team, and for whatever reason the widgets I place are multiplying. I have copied/pasted some, but other I have just added I am ending up with dashboards that look like this: When originally I only had the top four items. It has happened on several different…
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
Showing "stacked" data / Statuses of items by swimlane
I have multiple items that each have their own statuses and that roll up to "workstreams" or swimlanes. On the dashboard, I would like to show the progress of the items by swimlane without breaking it out into separate widgets for each. This would ideally be a stacked bar where each bar represented the Items and was broken…