Hey - I am new to this forum and look forward to recieving answers to many questions in the future. I am fairly new to Excel, so some of my questions may be extremely simple, but any help will be appreciated.

What I am trying to do....

I have 2 columns that I am concerned with. Column 1 contains a list of numbers. Column 2 contains either "W" (win) or "L" (loss). I want to perform a count of how many times "W" and "L" appear, but I want the count to be specific to the number in column 1. Ex...If value of column 1 is "5", how many are "W" and how many are "L". I have experimented with all possible variations of the COUNTIF function, but have had no luck. I apologize if this is confusing or worded wrong. Thanks in advance for any replies.