Calculating hours per week spent by a resource
 

Dear Excel-lent users,

Could you please help me with the following challenge ?

In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28
In Column 1 (A3:A24) I have the names of the resources

Per week I fill in the hours per resources for different tasks, so one name
will occur multiple times in Column 1. The hours are filled in in the Area
B3:AC24.

Now I want to know per week how many hours 1 resource is booked.

Could you please help me with a formula to calculate this?

Thank you very much !!

Jaydubs !

Calculating hours per week spent by a resource
 

One way:

Create another sheet with a unique list of resources in A2:An, week numbers
in B1:AC1, enter this formula in B2, and fill it to the right an down:

=SUMPRODUCT(--(Sheet1!$A$3:$A$13=$A2),Sheet1!B$3:B$13)

Adjust ranges!

--
Regards!
Stefi



€žThe Fool on the Hill€� ezt Ã*rta:

Dear Excel-lent users,

Could you please help me with the following challenge ?

In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28
In Column 1 (A3:A24) I have the names of the resources

Per week I fill in the hours per resources for different tasks, so one name
will occur multiple times in Column 1. The hours are filled in in the Area
B3:AC24.

Now I want to know per week how many hours 1 resource is booked.

Could you please help me with a formula to calculate this?

Thank you very much !!

Jaydubs !

Hours per week per resource
 

Dear Excel-lent users,

I want to know how many hours a resource is booked per week, knowing they
have multiple tasks per week. I have two sheets in which I want to process
the hours per task per week per resource (Sheet 1) and in Sheet 2 I want to
know what the total hours per week are one resource has been booked for.

For Sheet 1:
-I have the names of the resources in column H (names can occur multiple
times).
-in Q3:AR323 I have the hours the are working on per task per week.

For Sheet 2:
In Row 2 (B2:AC2) I have the numbers of the week starting from 1 till 28
In Column 1 (A3:A24) I have the names of the resources

Can someone please help me with this?

Thank you !!

Kind regards