scottwisler
New Member
- Joined
- Jan 7, 2014
- Messages
- 19
Hello all! thanks in advance for any assistance! I am using Excel 2003 and trying to calculate the number of wins based on a set schedule of 5 game matches as follows: (MATCH - UPS is in A11, etc) I previously only had 3 games and nested if/than,s but since I am in 2003 and now have 2 more games in each matchup, the formula is too long.
<colgroup><col width="219" style="width: 164pt; mso-width-source: userset; mso-width-alt: 8009;"> <col width="27" style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;" span="2"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="5"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="4"> <tbody>
</tbody>
MATCH - UPS | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 | |||||||
1 vs 3 | 1 | 3 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
6 vs 8 | 6 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
5 vs 7 | 5 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 4 | 2 | 4 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
6 vs 7 | 6 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
5 vs 8 | 5 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 3 | 2 | 3 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 4 | 1 | 4 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 5 | 1 | 5 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 6 | 2 | 6 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
4 vs 8 | 4 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
3 vs 7 | 3 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 5 | 2 | 5 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
3 vs 8 | 3 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 6 | 1 | 6 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
4 vs 7 | 4 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
4 vs 6 | 4 | 6 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 7 | 1 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 8 | 2 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
3 vs 5 | 3 | 5 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
2 vs 7 | 2 | 7 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
4 vs 5 | 4 | 5 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 8 | 1 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
3 vs 6 | 3 | 6 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
3 vs 4 | 3 | 4 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
1 vs 2 | 1 | 2 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
5 vs 6 | 5 | 6 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
7 vs 8 | 7 | 8 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 | 21 | 20 |
<colgroup><col width="219" style="width: 164pt; mso-width-source: userset; mso-width-alt: 8009;"> <col width="27" style="width: 20pt; mso-width-source: userset; mso-width-alt: 987;" span="2"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="5"> <col width="54" style="width: 41pt; mso-width-source: userset; mso-width-alt: 1974;"> <col width="47" style="width: 35pt; mso-width-source: userset; mso-width-alt: 1718;" span="4"> <tbody>
</tbody>