I've used SUMPRODUCT in the attached. It can also be done with SUMIFS but it's far less easy to read.

Hope it makes sense. Feel free to clarify if not.