Searching for data in another sheet that match the conditions

For example i take first line name:cristine...years:3.....place:A. I must insert a function that looks in sheet 2 for the same parameters cristine 3 A, and count how many they are and put the count number in the count column. In this sample the result is 2:count=2. Next for michael 3 A :count=1

Any help would be greatly appreciated.
Thank you.

Regards,
Michael

AttachmentSize
Sample1.xlsx10 KB
Nick's picture

have you looked at using a