I'm trying to do a sumifs or sumproduct with multiple criteria. I have lookups both vertically and horizontally and want the sum of the number that matches all criteria. If I needed no sum, I can do an index match, match, match, match. If I only had horizontals or verticals I can figure out sumifs or sumproducts but I can't seem to get it to work.
For example, in the picture, if it was working correctly, the answer would be 45.
Please help. Thank you.
For example, in the picture, if it was working correctly, the answer would be 45.
Please help. Thank you.