software

I have two columns: Col A contains part numbers, some of which are the
same. Col B contains quantities for each part number. Because some of
the part numbers are repeated, I need to add all the quantities for a
specific part number.

How do I SUM the quantities and group the part numbers in one single
function? Example:

Col A Col B

abc 10
abc 9
abc 8
def 5
ghi 3
ghi 8

I want to end up with:

Col A Col B
abc 27
def 8
ghi 11

Please help.
Jennifer--
Jennifer Brodie
------------------------------------------------------------------------
Jennifer Brodie's Profile: www.excelforum.com/member.php...oamp;userid=30792
View this thread: www.excelforum.com/showthread...hreadid=504514I recommend you check out the Data gt; SubTotals feature............

Vaya con Dios,
Chuck, CABGx3
quot;Jennifer Brodiequot; wrote:

gt;
gt; I have two columns: Col A contains part numbers, some of which are the
gt; same. Col B contains quantities for each part number. Because some of
gt; the part numbers are repeated, I need to add all the quantities for a
gt; specific part number.
gt;
gt; How do I SUM the quantities and group the part numbers in one single
gt; function? Example:
gt;
gt; Col A Col B
gt;
gt; abc 10
gt; abc 9
gt; abc 8
gt; def 5
gt; ghi 3
gt; ghi 8
gt;
gt; I want to end up with:
gt;
gt; Col A Col B
gt; abc 27
gt; def 8
gt; ghi 11
gt;
gt; Please help.
gt; Jennifer
gt;
gt;
gt; --
gt; Jennifer Brodie
gt; ------------------------------------------------------------------------
gt; Jennifer Brodie's Profile: www.excelforum.com/member.php...oamp;userid=30792
gt; View this thread: www.excelforum.com/showthread...hreadid=504514
gt;
gt;