Select the part numbers header included, do datafilteradvanced filter,
select unique records only and copy to another location, assume that the
original part numbers are in A1:A1000, assume that you copied the unique
list to H1:H200, now in I2 put

=SUMIF($A$2:$A$1000,H2,$C$2:$C$1000)

copy down all adjacent unique records


--

Regards,

Peo Sjoblom


"Larry Wallis" wrote in message
...
I have a simple spreadsheet in the following format ...

Cell A1 with a heading Part Number, B1 heading Description and C1 heading
Quantity.

Under the headings is a list of 100 rows and a part number can appear more
than once.

What I would like to do is take all the unique part numbers and put them
into a separate list and then sum the totals for these part numbers.

Can anyone give me and idea how to do this please?

Many thanks.

--
Larry Wallis.