Sorting a long list of repeating items and numbers

[alaska45]

Okay, I have a long table of work codes that repeat many times throughout the table and they are put in each day with the amount of hours worked on them in the next column. What I am wondering if i can do is input the two columns into something or a formula so it will sort it and give the total amount of hours for each work code. For example the table could be 100 rows longs with 5 varieties of the work codes repeated diiferent amounts of times within the rows, and each row has a work code and one column over is a number for the amount of hours for that work code. So how would get it so there is a table with the 5 work codes and the total number of hours for each code without having to look through the whole thing and inputting each number.
Thank You,
Colt M.

 

[West Man]

It sound like sumif would work for you.

 

[konew1]

Use a pivot table if you don't want to extract a list of valid codes