Searching columns, summarizing, and totalling?

I have an Excel spreadsheet that my company uses as a "cutbill" to send to the shop floor for production purposes. One of the columns of this cutbill contain part numbers from our inventory system.

Typically there are mulitple occurances of a part number with a quantity formulated for each entry.

At the bottom of the spreadsheet (outside of the print area) I would like to generate a summarized bill of material. I need Excel to scan a column of part numbers, generate a "simplified" list of part numbers, and totalling the "like" occurances.

Our inventory system has a HUGE amount of numbers, and I'm not sure how to have Excel to search for a "mystery" number. As the part numbers change with the job, and new numbers are constantly being generated.

What is the easiest way to do this? I'm not an Excel expert, but I can usually fumble around in there and get it to do what I need it to.

Thanks for any suggestions.
Drew

Drew, I think the easiest way to get your summary is to copy your sheet, sort
based on part number and then use data - subtotals to get the quantity for
each part number. HTH
--
Sincerely, Michael Colvin


"Drew H" wrote:

>
> I have an Excel spreadsheet that my company uses as a "cutbill" to send
> to the shop floor for production purposes. One of the columns of this
> cutbill contain part numbers from our inventory system.
>
> Typically there are mulitple occurances of a part number with a
> quantity formulated for each entry.
>
> At the bottom of the spreadsheet (outside of the print area) I would
> like to generate a summarized bill of material. I need Excel to scan a
> column of part numbers, generate a "simplified" list of part numbers,
> and totalling the "like" occurances.
>
> Our inventory system has a HUGE amount of numbers, and I'm not sure how
> to have Excel to search for a "mystery" number. As the part numbers
> change with the job, and new numbers are constantly being generated.
>
> What is the easiest way to do this? I'm not an Excel expert, but I can
> usually fumble around in there and get it to do what I need it to.
>
> Thanks for any suggestions.
> Drew
>
>
> --
> Drew H
> ------------------------------------------------------------------------
> Drew H's Profile: http://www.excelforum.com/member.php...o&userid=37481
> View this thread: http://www.excelforum.com/showthread...hreadid=571400
>
>