Grouping
 

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: http://www.excelforum.com/member.php...o&userid=30792
View this thread: http://www.excelforum.com/showthread...hreadid=504514

Grouping
 

I recommend you check out the Data SubTotals feature............

Vaya con Dios,
Chuck, CABGx3



"Jennifer Brodie" wrote:


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: http://www.excelforum.com/member.php...o&userid=30792
View this thread: http://www.excelforum.com/showthread...hreadid=504514