Counting Entries If Adjacent Box Matches

Im trying to make an excel spreadsheet for work for working out how many of each product and individual staff member has sold

I have 2 columns one with staff and one with what they sold e.g.

Staff Member - Sales
Staff 1 - prod A
Staff 2 - prod B
Staff 3 - prod A
Staff 2 - prod C
Staff 1 - prod A

and have another table, the one that i want to populate, that looks like this

Staff 1
prod A =
prod B =
prod C =

Staff 2
prod A =
prod B =
prod C =

etc

I cant seem to find a function that will work out how many of prod A staff 1 has sold and how many prod B he has sold etc

i have tried things like countif but i cant seem to get them to link the staff member and sales boxes together, the only way i can think of is to write down an equation for each line, but i have hundreds of sales and that would takes ages