Or another option is to use a Pivot Table.

Make sure the active cell is somewhere in the range A3:B2163 and
choose DataPivotTable then click NextNextFinish

Drag the column B field heading into the "Drop Data Items here" area,
and the column A field heading into the "Drop Row fields here" area.

You've now got a table of part numbers and quantities. If you really
need to, you could copy this table and paste it into columns C&D on
your original sheet, but you'll probably find you've no need.

HTH


On 28 Aug 2006 06:57:33 -0700, "Ben" wrote:

I have a psreadsheet that has Part Numbers on columns A3:A2163 and the
quantities on column B3:B2163.

Some of the part numbers have repeats so I want to set it so that the
formula will add the repeating part number quantities.

So I want column C to include the part number and column D to include
the subtotal quantity for that part number.

I would really appreciate the help.

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________