Looking for function to help ease my job

I have an excel spreadsheet with 5762 records. I have used conditional formatting to highlight the cells containing duplicates values. I need to then add those duplicates up.

IE:

ID BAL
1 10
1 10

I need to figure out a way to add the balances together based on them being the same id# if thats even possible. I sorted my sheet out by cell color and I have a thousand or duplicates highlighted. I have been manually going to the cells and doing =sum(i1,i2)

Any help would be greatly appreciated, I have a feeling I will be getting more data with the same problem I am facing now.

Something like this?

sumproduct-duplicates.xlsx

use SUMIF function

=SUMIF($B$1:$B$100,$A$1:$A$100,A1)

Where $B$1:$B$100 is the range to sum up
$A$1:$A$100 is the range of IDs
A1 is the first ID
Put this formula in cell C1 then copy this formula all the cells up to C100

My excel spreadsheet has more columns and data and I don't want to totally remove the duplicates as I want to add only the balance columns that have the same id # if that makes sense.

My post above is only calculating the totals of duplicates.

Opening now was sketchy because I did not notice it was an attachment thought it was a website ha

Is there anything special I need to do, or do I need to create an additional column

Yes, as the other contributors suggested you just need a column of unique values somewhere.

For example, assume you have put it in Column O:

O1 = 1, O2 =IF(COUNTIF($A$2:$A$8,O1)>1,SUMPRODUCT(($A$2:$A$8=O1)*($B$2:$B$8)),"No Duplicates")

Once you have your list in O, and the first formula entered in O2, you can copy and paste it down for every other ID in O.



Formula Logic: If Unique ID exists more than once, add up every instance of balance. If it only exists once, say "No Duplicates"

I got it working thanks to you guys/gals

No problem. I usually learn something from each request.