"Peo Sjoblom" <terre08@mvps.org> wrote in message
news:uFUTOD4DFHA.1292@TK2MSFTNGP10.phx.gbl...
> Select the part numbers header included, do data>filter>advanced 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" <larrywallis@CHEATTHESPAMgmail.com> wrote in message
> news:CamdnVlVptQk6ZbfRVnyiQ@pipex.net...
> > 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.
> >
> >
>
>

Excellent. Thanks Peo.

--
Larry Wallis.