Hello there

My laptop is on the brink of being destroyed, on account of Excel not cooperating with me. I'd love some assistance with this one. I have an inventory system which is quite manual, and currently I spend time manually adding up T-Shirt sales by date, style, colour and size. From my point of sale system I get one extract of data, and then my inventory sheet tally's everything up by these factors. In the attached example, AJ4 on "Test Inventory.." should calculate on which specified date did I sell the staple tee in the colour white and size small. An added factor as well is that the way my data comes out is that it has quantity of same item sold, but these are not separate line items.

I can't seem to get this to work for me at all - I've tried a few difference things but I think this is beyond my level of knowledge. Could anyone shed some light?

Cheers
Daniel

Excel Help Test.xlsx