Sum if based on two criteria

The way you are swapping ranges between horizontal and vertical is not going to work plus the ranges need to be equal in size.

Here is how I would do it (or at least this is what comes to mind). On the Master (2) tab added a helper column in AC. On Sheet6 used an Index/Match CSE function.