Win-Loss by League

[jfrank1034]

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

Result	Team
W	A	Team A W's	L's	Tie
W	B
W	C	Team B W's	L's	Tie
L	A
L	A	Team C W's	L's	Tie
W	B
L	B
W	C
L	C

<tbody>
</tbody>

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.