# SUMIF with INDEX MATCH Issue

#### clarkerots

##### New Member
I have the following data:

 A B C D E 1 Team 1 1 Team 2 2 2 Team 3 2 Team 4 1 3 Team 1 1 Team 3 2 4 Team 4 1 Team 1 2 5 Team 2 2 Team 1 1 6 7 Team 1-Wins Team 1-Losses

<tbody>
</tbody>

Whenever a team wins, a 1 is entered manually into Column B or Column D. Whenever a team loses, a 2 is entered into Column B or Column D. I'm trying to create a formula that will give me Team 1 wins in B7, and Team 1 losses in D7. I'm guessing that a SUMIF would cover the task of totaling 1's or 2's, but whenever I try to couple it with a INDEX MATCH in order to sum just Team 1 information, I can only get it to read the first instance of Team 1. The final formula should read the 1's in B1, B3, and D5 to give Team 1 3 wins in B7, and read the 2's in D4 to give Team 1 1 loss in D7. Is there a way to accomplish this combination? Any help appreciated greatly!

#### FormR

##### MrExcel MVP
Hi, something like this maybe:

#### bosco_yip

##### Well-known Member
Or,

[B7] =COUNTIFS(A1:C5,"Team 1",B1:D5,1)

[D7] =COUNTIFS(A1:C5,"Team 1",B1:D5,2)

Regards

Last edited:

#### clarkerots

##### New Member
That is awesome. Thank you both!