Hi,

I need to be able to do the following but i can not quite arrange the
formula corectly....

I have one sheet that has all the weeks in coulumns (for a project). In
another sheet i have this

A B C D E
Analysis Task 3 12/04/2010 14/04/2010
Task 5 15/04/2010 21/04/2010
Task 3 22/04/2010 26/04/2010
Task 10 27/04/2010 10/05/2010
Task 6 11/05/2010 18/05/2010
Analysis Task 2 11/05/2010 12/05/2010
Develop Task 4 13/05/2010 18/05/2010
Task 3.5 13/05/2010 18/05/2010
Analysis Task 1 13/05/2010 13/05/2010
Develop Task 2.5 14/05/2010 18/05/2010
Task 5.8 14/05/2010 21/05/2010
Analysis Task 2 14/05/2010 17/05/2010
Develop Task 3.8 18/05/2010 21/05/2010


I would like ini the calendar sheet to sum by week and by resources the
amount of hours being used...any ideas?

Thought this might work....but not sure...

Sumif(calendarsheet D1,calendarE1={projectsheet D1:D6, project sheet
E1:E6}and{
project sheet"analysis","develop",project}*(projectsheetC1 :C6)