clarkerots
New Member
- Joined
- Mar 29, 2019
- Messages
- 10
I have the following data:
<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!
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!