A | B | C | D | E | F | G | H |
1 | PITCHERS | WIN | LOSS | DATE | WIN | LOSS | PITCHER |
2 | DAVIS | 3/30 | 1 | DAVIS | |||
3 | SMITH | 3/31 | 1 | SMITH | |||
4 | JONES | 4/1 | 1 | JONES | |||
5 | WILLIAMS | 4/2 | 1 | WILLIAMS | |||
6 | 4/3 | 1 | DAVIS | ||||
7 | 4/4 | 1 | SMITH | ||||
8 | 4/5 | 1 | JONES | ||||
9 | 4/6 | 1 | WILLIAMS | ||||
10 | 4/7 | 1 | DAVIS | ||||
11 | 4/8 | 1 | JONES | ||||
12 | 4/9 | 1 | SMITH | ||||
13 | 4/10 | 1 | WILLIAMS | ||||
14 | 4/11 | 1 | DAVIS | ||||
15 | 4/12 | 1 | JONES | ||||
16 | 4/13 | 1 | SMITH | ||||
17 | 4/14 | 1 | WILLIAMS |
<tbody>
</tbody>
How can I properly write formulas in cells C2 thru C5 to count the number of wins in column F throughout the season to match the pitcher in column J.
I also want to write the same formula in cells D2 thru D5 to count the number of losses in column G throughout the season to match the pitcher in column J.
Thanks in advance!