"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:%236BdNk4DFHA.3924@TK2MSFTNGP09.phx.gbl...
> Hi Larry
>
> just a note on Jim's comments - it's important to SORT by part number
before
> using data / subtotals ...
>
> an alternative approach is using Pivot Tables - Debra Dalgleish has some
> good instructions on her website at www.contextures.com/tiptech.html
>
> Cheers
> JulieD
>
> "Jim Cone" <jim.coneXXX@rcn.comXXX> wrote in message
> news:%23DfLZV4DFHA.3972@TK2MSFTNGP15.phx.gbl...
> > Larry,
> >
> > Another way is to use the subtotals feature
> > Go to the Data menu and click Subtotals, follow the directions.
> >
> > Regards,
> > Jim Cone
> >
> >
> > San Francisco, USA
> >
> > "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.
> >
>
>

And thanx to you too Jim and Julie.

--
Larry Wallis.