Create a list with distinct values by select column A including the header,
then do datafilteradvanced filter, select copy to another location and
unique records, then use something like

(assume the filtered list starts in H2 with the header in H1)

=SUMIF(A:A,H2,B:B)

then copy down


--


Regards,


Peo Sjoblom


"irvine79" wrote in message
...
Column A contains part #s that are listed a varying amount of times
F8Z100
F8Z100
F8Z101
F8Z102
F8Z102
F8Z102
F8Z102

Colum B contains a value associated with the part # in column A
10
15
12
15
11
9
3

In Column C I want a formula that totals the values from Column B if they
have the for the same part # in Column A. (Desired result below)
25
12
-
-
-
38