Sum of a range where multiple column criteria and row criteria

Hi guys,

I am looking to sum a range of cells whereby the criteria is e.g. shop AND manager AND sep-18 - to populate the tables on the right.


Screen Shot 2018-05-21 at 17.36.21.png


I would appreciate some help, thanks!