Sub-totals and totals in large worksheet

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
425
Office Version
  1. 365
Platform
  1. Windows
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...
 

Some videos you may like

Excel Facts

Get help while writing formula
Click the italics "fx" icon to the left of the formula bar to open the Functions Arguments dialog. Help is displayed for each argument.

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
425
Office Version
  1. 365
Platform
  1. Windows
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...
 

Watch MrExcel Video

Forum statistics

Threads
1,118,295
Messages
5,571,388
Members
412,386
Latest member
Yasaman
Top