Analyzing Baseball Stats

I am using Excel to analyze several columns of baseball stats. I want to be able to sort through the list and find out how many particluar players from a particular team achieved something in the same year.

My data is in columns such as player, team, year, HR, Hits, RBI, etc......

For example, I want to sort through the data and count the number of Cub players who hit 20 homers in the same season. How do I get the COUNTIF function to do this? I've tried using COUNTIF in formulas with IF and AND statements but get incorrect results.

Thanks,

madmanmac