Counting with specific factors

[shaftdx]

Ok this one is just for fun so I can learn and have a frame of reference later on if need be. I am creating a sheet that tracks my favorite Hockey team. Schedule, scores and what not. I want one column to count how many times we have played a certain team (I have that one figured out) but in the next column I want a count of how many times we won against that team)
I have this on 2 separate sheets so I can add on to it season by season.

m.

 

[shinigamilight]

=COUNTIFS(Sheet1!$F$2:$F$10,"Win",Sheet1!$C$2:$C$10,Sheet2!A3)

 

[shaftdx]

=COUNTIFS(Sheet1!$F$2:$F$10,"Win",Sheet1!$C$2:$C$10,Sheet2!A3)

Worked exactly right! thank you!!