Hey guys.

So, I need your help again. This time I need help with COUNTIFS formula.

sample3.xlsx

As you can see from my file, I have 2 sheets. My MAIN DATA is in Sheet 1.

What I want to know is this:

1. What formula should I use to count how many wins and loss did both teams made. On sheet 2, B3, should display the number of WINS and on C3 the number of Loss of A3.
Same goes for the other team, the wins of A4 should display on B4 while loss should be on C4.

2. I've tried the COUNTIFS formula for this. Unfortunately, it only give me 0 as return. I am not sure what's going on there.
The code I used for Win is this:
=COUNTIFS(Sheet1!$C$3:$C$23,$A3,Sheet1!$G$3:$G$23,$B$2)
And for loss:
=COUNTIFS(Sheet1!$C$3:$C$23,$A3,Sheet1!$G$3:$G$23,$C$2)
Please let me know whats wrong with my formula. Thanks a lot guys!