Summing value and quantity of entered items, seperated by type

**Voidheartd** · 12-04-2012, 04:27 PM

At my current job I have to enter value and sometimes quantity totals from shipping invoices by HTS code, ECCN, and country of origin. I'm just curious if it's possible to setup 2 sheets in excel to allow me to enter the quantity, value, HTS code, ECCN, and COO for each item on the invoice, and have those totaled on the other sheet. It would need to have separate totals for anything with a different HTS, ECCN, or CO. This would be extremely helpful to me and my coworkers on the invoices that are overly long.

For example:

HTS ECCN CO Quantity Value
1234567890 EAR99 US 5 10.40
1234567890 EAR99 TW 7 15
1234567890 EAR99 US 3 5

Would show up on the 2nd sheet as:

HTS ECCN CO Quantity Value
1234567890 EAR99 US 8 15.40
1234567890 EAR99 TW 7 15

Is it possible to do something like this in Excel? I'm sure I could setup this in Access, but it isn't on the computers at work. I'll have to check but I think the work systems have Excel 2003.

Thanks for your help.

**ConneXionLost** · 12-04-2012, 04:36 PM

Yes, this is possible using pivot tables, or the SUMPRODUCT function.

Post a sample workbook of your intended layout.

How to attach a sample Excel workbook:

1. Below the "Quick Reply" thread frame, click the "Go Advanced" button.
2. On the edit toolbar, click the "Attachments" button.
3. In the "File Upload Manager" window, click the "Add Files" button.
4. In the "Upload Files from your Computer" window, click the "Select Files" button.
5. In the Windows Explorer window, locate and select your workbook, then click the "Open" button.
6. In the "Upload Files from your Computer" window, click the "Upload Files" button.
7. In the "File Upload Manager" window, click the "Done" button (lower right of screen).