How many hours per resource booked per week
 

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

How many hours per resource booked per week
 

Fool on the Hill -

Try a pivot table with the users as the row heading and the date as the
column heading - you can format the date to use weeks, etc. Then use the
sum(Hours) as the value.
--
Daryl S


"The Fool on the Hill" wrote:

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

How many hours per resource booked per week
 

Hello Daryl,

Unfortunately that does not work, I get an error message stating something
wrong with the heading. I think I need something with sumif or sumproduct,
but I am not sure.

Kind regards,

Jaydubs

"Daryl S" wrote:

Fool on the Hill -

Try a pivot table with the users as the row heading and the date as the
column heading - you can format the date to use weeks, etc. Then use the
sum(Hours) as the value.
--
Daryl S


"The Fool on the Hill" wrote:

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