Sum Total Weekly Hours in Random Date Ranges

[lifeguard23]

I have a spread sheet that I use to track various employees hours on various design projects. Each employee creates one tab for each month. In addition to the total hours that I can easily sum at the end of the month, I'd like to be able to see how many hours per week the person does. The issue is that hours are organized per project. The date is in Column A. The Total hours is in Column C. I want to figure out a way in which I can produce how many total hours occured during each week of that month (ie. Sept 4-10, 11-17, 18-24, etc.) as shows in K2:M6.

File:
https://dl.dropboxusercontent.com/u/5892902/hour_tracking.xlsx

 

[lifeguard23]

Still looking for some ideas if anyone has any...

 

[MARZIOTULLIO]

Hi

If you change in this way


[TABLE="class: grid"]
<tbody>[TR]
[TD][/TD]
[TD]

K​

[/TD]
[TD]

L​

[/TD]
[TD]

M​

[/TD]
[TD]

N​

[/TD]
[/TR]
[TR]
[TD]

1​

[/TD]
[TD]WEEK[/TD]
[TD]DATES[/TD]
[TD]DATES[/TD]
[TD]TOTAL HOURS[/TD]
[/TR]
[TR]
[TD]

2​

[/TD]
[TD]Week 1:[/TD]
[TD]

4-Sep​

[/TD]
[TD]

10-Sep​

[/TD]
[TD]

0.00​

[/TD]
[/TR]
[TR]
[TD]

3​

[/TD]
[TD]Week 2[/TD]
[TD]

11-Sep​

[/TD]
[TD]

17-Sep​

[/TD]
[TD]

23.00​

[/TD]
[/TR]
[TR]
[TD]

4​

[/TD]
[TD]Week 3[/TD]
[TD]

18-Sep​

[/TD]
[TD]

24-Sep​

[/TD]
[TD]

25.25​

[/TD]
[/TR]
[TR]
[TD]

5​

[/TD]
[TD]Week 4[/TD]
[TD]

25-Sep​

[/TD]
[TD]

30-Sep​

[/TD]
[TD]

7.75​

[/TD]
[/TR]
</tbody>[/TABLE]


n2=SUMPRODUCT(($A$9:$A$46>=L2)*($A$9:$A$46<=M2)*(ISNUMBER($C$9:$C$46)),$C$9:$C$46) copy down