# Sub-totals and totals in large worksheet

#### Dan Wilson

##### Active Member
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...

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

#### acw

##### MrExcel MVP
Dan

Have you tried Pivot Tables?

Tony

#### Dan Wilson

##### Active Member
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...

Replies
1
Views
110
Replies
10
Views
139
Replies
7
Views
115
Replies
4
Views
171
Replies
2
Views
652

Threads
1,118,278
Messages
5,571,279
Members
412,374
Latest member
Nagelgal