multiple criteria for calculations

Okay. Try this. Yellow cells needed data and grey cells are autocalculated. You can change colors later when sheets is finished if you desire.

Try the scenario you posed in your example and see if the results are correct.

If its not there may be an issue with a formula. Save it with the error and below replace the grey cells with what the desired results should be and i will make it happen.