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
Jase AlexanderCompliance ManagerAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
have you tried pivot table which looks something likePivototable
0
 
Jase AlexanderCompliance ManagerAuthor Commented:
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
0
 
Saqib Husain, SyedEngineerCommented:
The formatting is manual
0
 
Jase AlexanderCompliance ManagerAuthor Commented:
Excellent Advice

Thank you again

J
0
All Courses

From novice to tech pro — start learning today.