I have a excel sheet with a team schedule on it with the teams bouncing back and forth between home and away. Is there a way to tally wins and losses for them auto based on the entering of the scores? I can set up the position column based on the rest. I really just need help with the formula to get it going. I also am trying to calculate points for and points against if that is possible too. I am assuming it would be similar to the formula for wins/lose columns. All the real info is in the attached doc.
Bookmarks