Help pulling info from a sports result table

I have a table for my sports team in excel, with opponent in column A, and Win or Loss in column B.

Opponent Result
A WIN
B WIN
C LOSS
D LOSS
C LOSS
C WIN
A WIN
B LOSS
D WIN
B WIN
C WIN
D LOSS
C LOSS

I was looking to have a side table referencing to the first, which lists our opponents in one column, then our head to head score in the second column. I have been trying to figure out a formula for this head to head score without much luck, where the "?"s are in the table below

Opp Overall Score
A ?
B ?
C ?
D ?

I guess it should be something along the lines of : if column A = opponentA and column B = win, add 1 &"-"& if column A = opponent A and column B = loss, add 1. However I have not been able to achieve this in my attempts using mostly IF and COUNTIF functions.

Any help would be greatly appreciated.

Hi SlatedFate

Have a look at the COUNTIFS function.

Ah this looks like just what I want. I feel silly now for not spotting this fuction. Thanks!

Glad you got it sorted