Microsoft Excel - Trying to count through multiple sheet where team name is in different location

I currently have a workbookwith 17 different sheets, titled week 1, week 2, week 3, week 4 etc.
each week contains 32 teams, 2 of which play each other each week. I have another cell which shows if the team won or lost for a given week.
I am looking to do a count of all wins for a particular team on one sheet.
I am thinking I have to set a string for the team name
I also want to set a counter and have it add 1 each time the 2 criteria are met (team name matches, and has a win in column 2 for that team)
any help is appreciated.

Ravens		27
Broncos	Win	49
Dolphins	Win	23
Browns		10
Vikings		24
Lions	Win	34
Raiders		17
Colts	Win	21
Chiefs	Win	28
Jaguars		2
Buccaneers		17
Jets	Win	18
Falcons		17
Saints	Win	23
Titans	Win	16
Steelers		9
Bengals		21
Bears	Win	24
Seahawks	Win	12
Panthers		7
Patriots	Win	23
Bills		21
Packers		28
49ers	Win	34
Cardinals		24
Rams	Win	27
Giants		31
Cowboys	Win	36
Eagles	Win	33
Redskins		27
Texans	Win	31
Chargers		28

Hello Stephen,
stephen_1.zip
This should let you do what you want. Sing out if you have any problems.
Regards
Harry

Harry,

Having issue getting it to work, thank you for the input, as I stated the teams are not always in the same position for each of the weeks, could that be causing the issue of #Ref error?

I think I see it now, will be back shortly...

yep got it thanks

only thing I am having an issue with is Broncos, I know they have 2 wins, individual sheets have win on 2 sheets, but total only shows 1

Ravens	2	27	14	30
Broncos	1	49	41	0
Dolphins	3	23	24	27
Browns	1	10	6	31
Vikings	0	24	30	27

formula for that cell is same as others
=SUMPRODUCT(--(T(OFFSET(INDIRECT("'"&$C$1:$F$1&"'!A3:A34"),ROW(INDIRECT("3:34"))-1,0,1))=$A4),--(T(OFFSET(INDIRECT("'"&$C$1:$F$1&"'!B3:B34"),ROW(INDIRECT("3:34"))-1,0,1))="Win"))

Hi Stephen,
You will have to change the -1 to -3 in two places. I think that might be the problem.
Regards
Harry

Awesome Harry, much thanks

Harry,

Sheet is working fine, Thanks again. I am now trying to get the average for each team per week, based on their scores from the previous weeks and thoughts?