Associating a list with positve and negative numbers formula

Here I am with yet another problem with my fantasy football league records (I've had a lot of much appreciated help from patient people on here. Thanks to those of you who have contributed your time for me on this).

Our league is composed of two divisions of 5 teams each. Therefore, each player has 4 opponents within their own division they play against during the season. I am trying to compile a won-loss-tie total against these teams within a division.

I have attached a condensed sample of our worksheet layout. Mike N plays against the other 4 teams that are highlighted in yellow to the left. I want to therefore only tally the wins, losses and ties versus those teams (which I’ve also highlighted in yellow in the row).

Row 30 has positive and negative numbers. The positive numbers are wins, the negatives are losses, and the zero is for a tie (rare, but possible chance of happening).

With the numbers I’ve provided, there would be one win, one loss and one tie against Mike N’s division opponents.

Is there a way of doing this?

Thanks,
Damian

It isn't working as you have it. I only have the divisions separated based on a list to the left. I have only highlighted the two divisions in different colors to help you see which teams belong to which divisions. The colors aren't automatically associated with each team.

I've tried to change the scores, players, etc to test and it doesn't seem to work.

Mahju,

You're very close to what I need but I don't think it is exactly how I need it to work. In row E14:J14 (and continuing on to the right) I want to put the opponent (from a drop down list, which I have already created in my master sheet I'm actually using).

The example uses Mike's results. Mike is from the yellow division, so I want the wins/losses against only those opponents (the other 4 in yellow) to automatically be totaled.

The way you have it seems to work, but not if I continue to add more results in columns to the right.