Grouping

[Jennifer Brodie]

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

[CLR]

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
>
>