Win-Loss by League

[jfrank1034]

So I am trying to track wins, losses and ties and by a certain league/team.

[TABLE="width: 250, align: center"]
<tbody>[TR]
[TD]Result[/TD]
[TD]Team[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]A[/TD]
[TD]Team A W's[/TD]
[TD]L's[/TD]
[TD]Tie[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]C[/TD]
[TD]Team B W's[/TD]
[TD]L's[/TD]
[TD]Tie[/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]A[/TD]
[TD]Team C W's[/TD]
[TD]L's[/TD]
[TD]Tie[/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]W[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]L[/TD]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So I want it to look at the result in Col A, then correlate to what team it is in Col B, then say in C3 (under A W's) It will count if the win is from team A, if the loss is from team A (D3) and so on. I'm thinking like an =if forumla but haven't tried out a lot yet. Thanks.

 

[bbott]

Take a look at the COUNTIFS function. It would look something like:

=COUNTIFS(A2:A10,"W",B2:B10,"A")

 

[Stridhan]

for Team A's wins

=COUNTIFS(A:A,"W",B:B,"A")

Just modify letters W and A to suite team and result

 

[jfrank1034]

Awesome thanks. COUNTIFS is what I was forgetting. Got it working.