I would like to sumifs for multiple criteria on a single range. I have seen someone using sumproduct(with sumifs).
However I couldn't get it to work properly.

I have attached a sample file to illustrate my problem.
sumproductsumifs.xlsx
The actual sum that I should be getting is 36962 but my formula only returns me 20908.

Please help to solve is it something wrong with how I construct the formula, or do you know of better ways to get the final result (pivot is not a choice for my problem).


Thanks,
Ray