Im having a hard time get the formula correct if its even possible.

I have a Win Loss Spread sheet and im trying to summerize it on one sheet by statistics through out a 17 week period.

each sheet is a week..week 1,2,3,4..so on.


I can summerize one week at a time but not all the sheets progressively.

If i try to add all the weekly tabs, with this formula, it gives me an error..
=SUMPRODUCT(--('Week 1 :[Week 17]Week 17'!C$9:$C$18="Casey"),--('Week 1 :[Week 17]Week 17'!I$9:$I$18="L"))

If I place this in for only one week tab it works fine.
=SUMPRODUCT(--('Week 1 '!$C$9:$C$18="Casey"),--('Week 1 '!$H$9:$H$18="L"))

anyone have any ideas or a simpler way?

Thanks!!!