Adding multiple values with same identifier

[tyler_catoctin]

I would like to add multiple cells in the same column in a separate tab. I have employees and I would like to total their hours. The download I pull from our clocking in system gives me a roll up of every clock in event that all of the employees make. So for a one week range there are multiple lines per employee (they clock in multiple time per week).

I would like to, in another tab, total the hours per week for each employee. How can I select and total the values?

Here is what it looks like:

Employee ID	Name	Date	Total Hours
1	John	4/5	3
2	Joe	4/5	2
2	Joe	4/6	6
3	Bob	4/5	8
4	Denise	4/5	4

<tbody>
</tbody>

I would like to get a total for Joe's hours. How do I select all of those values and total them in a separate tab?

Thank you!

 

[tyler_catoctin]

I figured it out. I used SUMIFS.

Thank you