How to Skip Cells in SUMIF Formula?

[vannelson]

I am working on a timesheet spreadsheet and have run into trouble.

Here is part of the sheet:
[TABLE="width: 960"]
<colgroup><col span="15"></colgroup><tbody>[TR]
[TD="colspan: 15, align: center"][/TD]
[/TR]
[TR]
[TD="colspan: 2"][TABLE="width: 960"]
<colgroup><col style="text-align: center;" span="15"></colgroup><tbody>[TR]
[TD="colspan: 15, align: center"]Week 1 of Pay Period
[/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]Sunday
[/TD]
[TD="colspan: 2, align: center"]Monday [/TD]
[TD="colspan: 2, align: center"]Tuesday[/TD]
[TD="colspan: 2, align: center"]Wednesday[/TD]
[TD="colspan: 2, align: center"]Thursday [/TD]
[TD="colspan: 2, align: center"]Friday [/TD]
[TD="colspan: 2, align: center"]Saturday[/TD]
[TD="align: center"]Total[/TD]
[/TR]
[TR]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[/TR]
[TR]
[TD="align: center"]job1
[/TD]
[TD="align: center"]3[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"]7[/TD]
[/TR]
[TR]
[TD="align: center"]Site
[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[/TR]
[TR]
[TD="align: center"]job2
[/TD]
[TD="align: center"]4[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
[TR]
[TD="colspan: 15, align: center"]Week 2 of Pay Period
[/TD]
[/TR]
[TR]
[TD="colspan: 2, align: center"]Sunday
[/TD]
[TD="colspan: 2, align: center"]Monday [/TD]
[TD="colspan: 2, align: center"]Tuesday[/TD]
[TD="colspan: 2, align: center"]Wednesday[/TD]
[TD="colspan: 2, align: center"]Thursday [/TD]
[TD="colspan: 2, align: center"]Friday [/TD]
[TD="colspan: 2, align: center"]Saturday[/TD]
[TD="align: center"]Total
[/TD]
[/TR]
[TR]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[/TR]
[TR]
[TD="align: center"]job3
[/TD]
[TD="align: center"]5[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"]11[/TD]
[/TR]
[TR]
[TD="align: center"]Site
[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[TD="align: center"]Site[/TD]
[TD="align: center"]Hours[/TD]
[/TR]
[TR]
[TD="align: center"]job4
[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]
[/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[TD="align: center"] [/TD]
[/TR]
</tbody>[/TABLE]

​

[/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD="colspan: 2"][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am trying to calculate the total hours per week at each site. Here is the formula I am currently using: =SUMIF(B3:B96,"612 job1",C3:C96)

However, it calculates for both weeks. I am looking for the solution to skip cells so I am able to calculate week 1 and week 2 separately.

Any feedback would be appreciated