COUNTIF Row if Criteria is met

[Pamam]

HI

i need help with a excel problem i am having, not sure if this requires more work outside of what excel can handle. I am also using excel 2010

i have 2 worksheets under the one file

One worksheet counts how many times a staff member is marked under a certain product code, (See screenshot 2 for sample data). Lets call this worksheet as TALLY
while the 2nd worksheet has the dates of the year and staff members. Each day is represented as the staff member working under a certain product code. So the first sheet will tally up the codes separately and give me a read out for the year. (See screenshot for sample data). Lets call this worksheet as YEAR TO DATE

Screenshot 2.JPG
Screenshot.JPG

My first worksheet has the following formula that works correctly for each product code and corresponding staff member
=COUNTIF('YEAR TO DATE'!$5:$5,Lookup!B$2)
but the data is calculated as i have specifically told the formula to look at row 5 to count the data for Staff 1. and i would do the same for the rest of the staff but telling it to look at a different row.

but as staff members arent always in the same row for the YEAR TO DATE for the entire year, as we have new starters added, i would like to use some sort of lookup that mentions

whatever is in the TALLY worksheet column A for each staff member, find the relevant row in YEAR TO DATE and countif the requried formula as above, rather than me having to specifically say in the formula go to row 1 etc

is this possible in the realms of excel formula's? or would i need to create custom actions?

if it helps me by uploading a sample version of what i need then i will do so

thanks