Sub-totals and totals in large worksheet

[Dan Wilson]

Good day. I have a customer using Excel 2003 on Windows XP Pro. They are currently creating estimates in Word and want me to find a way to give them sub-totals and totals on the data. I can import the document into excel and end up with four columns of data. Column A contains the quantity of a particular part, Column B contains the part description, Column C contains the vendor of the part and Column D contains vendor part number.

The problem is that the document contains repeats of given part numbers. The customer is a lock and key shop and they specialize in custom installations. Thus, their document will contain a list of parts to be installed per door. The list can contain the same part number for each of the doors. They want me to show a subtotal of parts for each door and a grand total of each individual part number for the entire job so that they can order the correct number of parts.

Anyone want to tackle this One? I have tried using SUMIF, COUNTIF, COUNTA and VLOOKUP, all with no success. Any help will be greatly appreciated.

Thanks, Danno...

 

[acw]

Dan

Have you tried Pivot Tables?


Tony

 

[Dan Wilson]

Reply to Tony

Good day Tony. Thanks for the quick response. I have no knowledge of pivot tables, but I'm willing to learn if that will work. I will consult my help file and my books.

Thanks, Danno...