2 worksheets
Worksheet 1 has a column with 100 names, with duplicates . In the cell
next to each name are numbers, with some blank cells.

In worksheet 2, I have all the previous names, but no duplicates. I want to
reference worksheet 1, looking for a name and then summing all the values
attached to that name. I don't want to count the names, but add the values
each time the name appears

Thank you for any help you can give me.