Sum of unique values in a column based on values in another column

Hello,
Please find an example of my data attached.


I have a list of customers in column A and # of units sold to them in column B. I need to come up with a formula that will sum up values in column B based on 'unique' values in column A. So, e.g. when it comes to summing up # of units sold to customer 100620, I only want to sum up 19 in the final total and not 38 as you can see in column B as the # of units sold to a customer 100620.


Very much appreciate your help in advance.
Thanks!

Cross post http://www.excelforum.com/excel-for...column-based-on-values-in-another-column.html

You might be able to accomplish this by using the SUMIF function.

pandyav said:

Very much appreciate your help in advance.

Click to expand...

You can extract the unique in column D.
If D2 condition then try formula

btw: see Unique vs Distinct