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

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

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