Rafsun Royal’s Profile

Community member since October 2018

points
82
Company
LERETA
Department
IT & Operations
Area of expertise
Project Management

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

7

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)

2

Hi,

I have total of 1200 tasks and 3 Assignees and I need to count : ( I want to create a Mini Dashboard on the top of my Task Sheet)

1. Total Number of 'Completed' by All 3 Assignees,

2. Total Number of 'Completed' by each of my Assignees.

3. How many tasks have been selected 'completed' from my

2

Currently I am working to create a statistics to show all the work status counts. I am using multiple formulas in different cell. Is there any way to hide the formulas OR create a duplicate linked sheet where the duplicate sheet will update at the same time when I will change anything to my

5

I want to count Total number of Pending Task, Completed Task, Not Started  for each of my team members from a different sheet (Master Daily Tasks Update-IT Dev Range) to a new sheet

 

Currently I am using this one to count total number of Pending Task: =COUNTIFS({Master Daily Tasks Update-IT Dev