match names sum all scores pretaining

[Wskip49]

I would to Match column A NFL teams with column G and sum all wins column J & L and column G and sum all Losses column K & M. I have tried sumif, sumifs, Index match but I can't seem to get those to work.

[JohnTopley]

What are we "summing": the numbers or "Won" or "Lost".

As you only have numbers in row 5 and no expected results ....????

[Wskip49]

I made changes and put some scores in wins and losses,

[josephteh]

Perhaps, C5=COUNTIFS(J$5:J$100,"<>",$G$5:$G$100,$B5)+COUNTIFS(L$5:L$100,"<>",$G$5:$G$100,$B5), copy down and across.

[Wskip49]

In the won and lost columns C & D. I'm tryig to get the (sum) total scores of all games played. Sum of all wins and sum of all losses. 3 games for each team and 4 for Las Vegas.

[JeteMc]

Seems like the following might work:
1. For cells C5:D36: =SUMIFS(J$5:J$100,$G$5:$G$100,$B5)+SUMIFS(L$5:L$100,$I$5:$I$100,$B5)
2. For cells E5:E36: =SUM(C5:D5)/A5
Let us know if you have any questions.

[Wskip49]

The first half of the formula works but the second half does not. It only give one score for a loss.

[JeteMc]

Not sure what that means.
Please tell us a few of the cells that are displaying incorrect results and what the correct results should be.

[Wskip49]

cells C5:C36 seems to work correctly summing the total wins of the three games played.
however, D5:D36 does not.

[JeteMc]

Here is the file with the formulas applied.
Please tell us which cells in column D are displaying incorrect results and what the correct results should be.

[Wskip49]

It works, than you so much.

[JeteMc]

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.