Welcome to the Board!
If you are using Excel 2007 or newer, on the Data Menu, under the Data Tools ribbon, there is a "Remove Duplicates" button.
You can use that to remove your duplicates, then run your SUM.
If you need to maintain all your original data, I would copy all your data to a new tab, then do the steps above on the copy.