Cannot get SUMPRODUCT to work with calculating inventory

Hello there,

I have a spreadsheet that has all my orders on the first tab. Then on the second tab I'm trying to calculate my Shirt sizes, color, *** so I can easily know what to order.

What's the best way to do this? Currently I am manually entering ***, size, color of each shirt type, then I tried SUMPRODUCT for my formulas. It's calculating the, but it's not correct. For instance, I have 1 Men, XXL, Royal shirt and it won't calculate it. It says 0 when I put my SUMPRODUCT formula in. but then Men, M, Royal calculates the total shirts correctly.

I would hope there's also a better way to do it so I don't have to type out my product out and it can pull the different varieties off the first tab to sort quantity by ***, size, color. Perhaps using INDEX somehow.

Can anyone help me with this formula and setting up my sheet? I'd be eternally in your debt! My spreadsheet is attached.

THANKS!
Lorne