Lookup to count completed work items by time

hi all, desp need some help on a couple of worksheets I have please !!

On my 1st worksheet I have a list of work items in Column A, repeats of names in column B, a Yes or No in column C, and then if there is a Yes in Column C there is a time in Column D. It basically checks for how many items of work people have been assigned, how many they have completed and the time they completed them at.

On another worksheet, I have a table with each of the individuals names in column A and then times from 10am to 5pm in columns B - I. I want this table to total up how many items of work each person has completed by that time. So if on the first worksheet, Sarah has 3 work items with yes's next to them and the times next to all 3 are before 10am, I want it to return 3 on Sarah's row under time 10am, and so on for each person and at each hour.

I have attached an example spreadsheet for you to have a look at, is this possible?

Would muchly appreciate your wise words !

Welcome to the forum, IzzyFizzyLove.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.