Counting By 2 Or More Criteria

i have to create a summary of the productivity of the administration staff in my office. i have a table of raw data that shows the jobs they open each day, but i need to find a way of counting the number of those jobs.

i've included an example so that its easier to understand what i'm getting at.

on the first sheet (Jobs) i have the table of raw data. each administrator opens jobs each day which can either be S (standard) or W (Warranty). the second sheet (Summary) shows the way i need the data to be summarised. effectively i need to narrow my count by 3 criteria (Date Opened, Job Type and Administrator).

i've used DCOUNT functions in the past to count data by more than 1 criteria, but as this system will be in place for every day of the year, that means i would have to produce a table for every administrator and every type of job and every day of the year. which would be 3650 different tables, and that's too many.

is there a way i can do this more effectively? or can i somehow make the DCOUNT tables relative so that the table can look up the date required, reducing the number of tables required to 10?