Hey, glad you have it all working.
Sorry about the faulty formula. I got doing some other things and missed that glitch.

Here is a fix that is a bit simpler than the one you are using:

=IF(AND(F72<>"BY Week",F74=""),"",IF(F79=IF(E72="BY Week",D79,E79),E80+1,1))

It would go in cell F80 and drag across to end of season. Then copy to each other team.
I haven't tested it on every team but it works for the first 2 and they have the only 2 possibilities that the formula checks for.

Enjoy the rest of the season.