=IF(((COUNTIF('Week 1'!E38:E53,"TIE"))+(COUNTIF('Week 2'!E38:E53,"TIE"))+(COUNTIF('Week 3'!E38:E53,"TIE"))+(COUNTIF('Week 4'!E38:E53,"TIE"))+(COUNTIF('Week 5'!E38:E53,"TIE"))+(COUNTIF('Week 6'!E38:E53,"TIE"))+(COUNTIF('Week 7'!E38:E53,"TIE"))+(COUNTIF('Week 8'!E38:E53,"TIE"))+(COUNTIF('Week 9'!E38:E53,"TIE"))+(COUNTIF('Week 10'!E38:E53,"TIE"))+(COUNTIF('Week 11'!E38:E53,"TIE"))+(COUNTIF('Week 12'!E38:E53,"TIE"))+(COUNTIF('Week 13'!E38:E53,"TIE"))+(COUNTIF('Week 14'!E38:E53,"TIE"))+(COUNTIF('Week 15'!E38:E53,"TIE"))+(COUNTIF('Week 16'!E38:E53,"TIE"))+(COUNTIF('Week 17'!E38:E53,"TIE")))=0,((COUNTIF('Week 1'!E38:E53,"TRUE"))+(COUNTIF('Week 2'!E38:E53,"TRUE"))+(COUNTIF('Week 3'!E38:E53,"TRUE"))+(COUNTIF('Week 4'!E38:E53,"TRUE"))+(COUNTIF('Week 5'!E38:E53,"TRUE"))+(COUNTIF('Week 6'!E38:E53,"TRUE"))+(COUNTIF('Week 7'!E38:E53,"TRUE"))+(COUNTIF('Week 8'!E38:E53,"TRUE"))+(COUNTIF('Week 9'!E38:E53,"TRUE"))+(COUNTIF('Week 10'!E38:E53,"TRUE"))+(COUNTIF('Week 11'!E38:E53,"TRUE"))+(COUNTIF('Week 12'!E38:E53,"TRUE"))+(COUNTIF('Week 13'!E38:E53,"TRUE"))+(COUNTIF('Week 14'!E38:E53,"TRUE"))+(COUNTIF('Week 15'!E38:E53,"TRUE"))+(COUNTIF('Week 16'!E38:E53,"TRUE"))+(COUNTIF('Week 17'!E38:E53,"TRUE")))&"-"&((COUNTIF('Week 1'!E38:E53,"FALSE"))+(COUNTIF('Week 2'!E38:E53,"FALSE"))+(COUNTIF('Week 3'!E38:E53,"FALSE"))+(COUNTIF('Week 4'!E38:E53,"FALSE"))+(COUNTIF('Week 5'!E38:E53,"FALSE"))+(COUNTIF('Week 6'!E38:E53,"FALSE"))+(COUNTIF('Week 7'!E38:E53,"FALSE"))+(COUNTIF('Week 8'!E38:E53,"FALSE"))+(COUNTIF('Week 9'!E38:E53,"FALSE"))+(COUNTIF('Week 10'!E38:E53,"FALSE"))+(COUNTIF('Week 11'!E38:E53,"FALSE"))+(COUNTIF('Week 12'!E38:E53,"FALSE"))+(COUNTIF('Week 13'!E38:E53,"FALSE"))+(COUNTIF('Week 14'!E38:E53,"FALSE"))+(COUNTIF('Week 15'!E38:E53,"FALSE"))+(COUNTIF('Week 16'!E38:E53,"FALSE"))+(COUNTIF('Week 17'!E38:E53,"FALSE"))),((COUNTIF('Week 1'!E38:E53,"TRUE"))+(COUNTIF('Week 2'!E38:E53,"TRUE"))+(COUNTIF('Week 3'!E38:E53,"TRUE"))+(COUNTIF('Week 4'!E38:E53,"TRUE"))+(COUNTIF('Week 5'!E38:E53,"TRUE"))+(COUNTIF('Week 6'!E38:E53,"TRUE"))+(COUNTIF('Week 7'!E38:E53,"TRUE"))+(COUNTIF('Week 8'!E38:E53,"TRUE"))+(COUNTIF('Week 9'!E38:E53,"TRUE"))+(COUNTIF('Week 10'!E38:E53,"TRUE"))+(COUNTIF('Week 11'!E38:E53,"TRUE"))+(COUNTIF('Week 12'!E38:E53,"TRUE"))+(COUNTIF('Week 13'!E38:E53,"TRUE"))+(COUNTIF('Week 14'!E38:E53,"TRUE"))+(COUNTIF('Week 15'!E38:E53,"TRUE"))+(COUNTIF('Week 16'!E38:E53,"TRUE"))+(COUNTIF('Week 17'!E38:E53,"TRUE")))&"-"&((COUNTIF('Week 1'!E38:E53,"FALSE"))+(COUNTIF('Week 2'!E38:E53,"FALSE"))+(COUNTIF('Week 3'!E38:E53,"FALSE"))+(COUNTIF('Week 4'!E38:E53,"FALSE"))+(COUNTIF('Week 5'!E38:E53,"FALSE"))+(COUNTIF('Week 6'!E38:E53,"FALSE"))+(COUNTIF('Week 7'!E38:E53,"FALSE"))+(COUNTIF('Week 8'!E38:E53,"FALSE"))+(COUNTIF('Week 9'!E38:E53,"FALSE"))+(COUNTIF('Week 10'!E38:E53,"FALSE"))+(COUNTIF('Week 11'!E38:E53,"FALSE"))+(COUNTIF('Week 12'!E38:E53,"FALSE"))+(COUNTIF('Week 13'!E38:E53,"FALSE"))+(COUNTIF('Week 14'!E38:E53,"FALSE"))+(COUNTIF('Week 15'!E38:E53,"FALSE"))+(COUNTIF('Week 16'!E38:E53,"FALSE"))+(COUNTIF('Week 17'!E38:E53,"FALSE")))&"-"&((COUNTIF('Week 1'!E38:E53,"TIE"))+(COUNTIF('Week 2'!E38:E53,"TIE"))+(COUNTIF('Week 3'!E38:E53,"TIE"))+(COUNTIF('Week 4'!E38:E53,"TIE"))+(COUNTIF('Week 5'!E38:E53,"TIE"))+(COUNTIF('Week 6'!E38:E53,"TIE"))+(COUNTIF('Week 7'!E38:E53,"TIE"))+(COUNTIF('Week 8'!E38:E53,"TIE"))+(COUNTIF('Week 9'!E38:E53,"TIE"))+(COUNTIF('Week 10'!E38:E53,"TIE"))+(COUNTIF('Week 11'!E38:E53,"TIE"))+(COUNTIF('Week 12'!E38:E53,"TIE"))+(COUNTIF('Week 13'!E38:E53,"TIE"))+(COUNTIF('Week 14'!E38:E53,"TIE"))+(COUNTIF('Week 15'!E38:E53,"TIE"))+(COUNTIF('Week 16'!E38:E53,"TIE"))+(COUNTIF('Week 17'!E38:E53,"TIE"))))
Bookmarks