asked on

Excel Grouping and Subtotalling using multiple criteria

HI Experts

Hope you can help

I have an invoice I need to subtotal using multiple criteria for the purpose of using for customs clearance in the USA

The problem I have is that Ive tried using the built in Grouping and Subtotalling functions however they don’t seem to give me the results I need.

Ideally, I need to the invoice to group by Columns A & B for both Country of Origin and Commodity Codes and with this data, subtotal the units and costs etc.

Ive tried various methods, including some VBA I found on a helpful site, but it does not seem to work.

I have attached the document in question – the Invoice sheet is the actual data with the Subtotal_Example sheet showing what, if possible, is required (or near to). I compiled this manually from the data so apologies if some of the values differ – it is just to highlight the kind of format I am desperate to achieve.

If you could help, I would be very appreciative

Thanks
J
EE_Help_SubtotallingInvoce.xlsx.xls

ASKER CERTIFIED SOLUTION

Saqib Husain

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jase Alexander

ASKER

Hey

Thank you so much for your help

I didnt even occur to me to pivot the data

Just one thing - how did you format the colours for the rows? Was this manual or is there a formatting option?

Thanks
J

Saqib Husain

The formatting is manual

Jase Alexander

ASKER

Excellent Advice

Thank you again

J