I have data in the following format:
A1 : @ANA
A2 : W
B1 : @TEX
B2 : L
C1 : TEX
C2 : W
etc etc (many many more)
These represent a list of opponents and outcomes (a win = "W", loss = "L"). Here is what I would like to do: I would like to output a tally of all the AWAY games that resulted in wins. In the case mentioned above, I would like the value to be "1", which corresponds to the data in A1, A2. I can't figure out how to get the value to return for the @TEAM coupled with the outcome W.
A1 : @ANA
A2 : W
B1 : @TEX
B2 : L
C1 : TEX
C2 : W
etc etc (many many more)
These represent a list of opponents and outcomes (a win = "W", loss = "L"). Here is what I would like to do: I would like to output a tally of all the AWAY games that resulted in wins. In the case mentioned above, I would like the value to be "1", which corresponds to the data in A1, A2. I can't figure out how to get the value to return for the @TEAM coupled with the outcome W.