Sub-totals and totals in large worksheet

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
407
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

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Dan Wilson

Active Member
Joined
Feb 5, 2006
Messages
407
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,113,993
Messages
5,545,377
Members
410,679
Latest member
rolandbianco
Top