presenting/totalling a value if the cell on one sheet matches multiple criteria on another

[nlweqfvneviepuctqm]

I have an order form that contains a load of products- product 1, 2, 3, etc. I have the dates that the order is expected. On a separate sheet all the orders are in a big long list. I need a formula that looks at the product name, ensures it is on the same row as the order date- then relays the amount on order. example spreadsheet attached.

link to example spreadsheet



any help, greatly appreciated

 

[RoryA]

This appears to be a duplicate of this thread, which you never followed up on. Thread closed.