Summarize multiple tabs

Hello everyone, 

 

I am stuck trying to make an overview of customer orders in the database in Excel,

It concerns around +/- 100 customers in the list, with about 1000 orders, with several columns of the products with the number of the order next to it. 

I want to create a summary of the total of every product that was ordered, every single product in quantity and (if possible) also a sum of the countries that order a specific product. (see beneath for an overview of what I mean, only more columns are in the actual sheet)

I have googled a bit, but I couldn’t find anything, so I hope someone here can help me out.

Thank you in advance!

(link image)

Table of products

 

By: Lev

Leave a Reply

Your email address will not be published. Required fields are marked *