View Single Post
  #1   Report Post  
Larry Wallis
 
Posts: n/a
Default How to consolidate/sum a list

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.