Hello. I have workbook that lists badge numbers in column A. Hours in column H. I want to be able to add up all the hours by badge id. The problem is the a badge number can appear multiple times. So a regular Vlookup will not work. I have also tried a sumif formula. This adds them up however, it shows the duplicate and I am not looking for the duplicate to be there. This workbook can have about 5,000 rows so I am not sure exactly how this can be done. The final result I just want all the hours added up in one row with no duplicates. Attached is a sample file for an easy example. John should be added up to 5 hours. Mary added up to 11 hours. David 7 hours. Thank you!