Calculate based on dates and names from the other table

[JustoneE]

Hi! I'm wondering if there is a way to calculate the total time taken by Name and Date.
I'm creating a separate UserForm ( Sheet 1: Click to calculate efficiency) to search for specific name and date and calculate a certain figure. Once the search button (cmdSearch) is clicked, the textbox for total review DHR (txtDHR) will immediately show the number. At the same time, if it is possible I would like the spreadsheet to automatically update itself at the total review DHR. The date stated will be everyday of the month, for example 2021-10-01, 2021-10-02 and etc , and I would need to do it for every name listed. I'm not very good at explaining so I'm uploading the excel sheet below with the codes and formula.

If I'm missing any important details, do let me know. Thanks in advance!

I'm sorry I didnt realise we're not supposed to cross post on multiple website, here is the link where I post the question on MrExcel.com: "mrexcel.com/board/threads/search-data-and-calculate-with-vba-userform.1189762/"

[sungjunbae]

Hi,

Just downloaded attached file and simply found out argument mistake of SUMIF function.
You can use function like: '=SUMIF(B11:B19, "Peter", F11:F19)' => sum of Time Taken by Peter, '$I$9' instead of "Peter" for formula.

Regards,