Two criteria met, show value: how?

[fritsvis]

Probably the answer is very simple, but I couldn't find it anywhere.

Here is the situation:

I have a lot of sheets with different customers. I want to have an overview on one sheet with my customers and what they ordered.

For example is want to know how much papaya I sold on 6th of June.

So:

DATE Product (which is a dropdown) Qty

Productcolumn is a dropdown. The data is pulled out of a table (named 'centrum1' of another worksheet. So at column 'Qty', it has to check date and product and then display the right amount of that day and the specified product.

So if I fill in another date of product, the data of Qty has to change.

Hope you can help, because I can't figure it out!

 

[Meggesto]

Can you organize your data in such a way that a pivot table would be capable of doing this for you?

 

[fritsvis]

Probably not, because it's like 30 different customer sheets. And it's organized a bit old fashioned, and changing is not possible I think.

How would it work with pivot tables? And is it possible without pivot table?

 

[Aladin Akyurek]

Try to create two small samples corresponding to two sheets along with the desired results.

 

[fritsvis]

But how?

 

[Aladin Akyurek]

But how?

Attachments lists a few methods for posting sample exhibits which do not require retyping and the add-in https://app.box.com/s/soezox25h3w0q5s4rcyl is also a method for posting an exhibit (Note that an image or a link to a storage site like dropbox or onedrive etc. does not provide a permanent record.). Mind you a forum without a permanent record is not of much value.