sumproduct formula to pull info from multiple sheets
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!!!
|