VBA.array to sum values based on multiple criterion and dates

Hi again,

I am looking to sum work hours based on a date and job positions.
What is needed is the sum of the work hours as well as the amount of people who worked that day.
I have fiddled a bit with the VBA.array to define the job positions, and some sort of looping to get through the rows, but I am not there at all.
The VBA I have so fare is selecting the cells that needs to be summed, but it is only with respect to the Position Title Name, not the date.

Attached is an example.
I would like to Add the data in sheet1 AZ:AZ to sheet2 under the right dates if: Position title name and date is corresponding to the criterion.

Any help is appreciated

If you can arrange your data so all columns are contigous, you can use a pivot table to get what you want. See attached file where I rearrange your data in new sheets.
Pierre