Count instance where multiple matches can occur and with multiple criteria

Hi all

In excel 2010 I have 2 worksheets.

Sheet 1- Worker

a b
Hit 37
Miss 38
Hit 38
Hit 38

A is if a staff member hit the target and b is the calender week that the target was hit.

Sheet 2

I have a dropdown box where you can select the calender week you wish to view in J2

Basically what I want to do is count the amount of instances where a staff member has hit the target for a particular week, so when you change the dropdown, the results for that week will be displayed.

I have tried Count, Countif, if and Dcount but I just cant seem to get it to work. I somehow managed to get a 1 displayed if they did meet target in that week, and false if not, but I just cant seem to figure out and 'If week x is picked in dropdown, count amount of hits for this week'

Many Thanks

Fantastic! Thanks