SUMIFS using SUMPRODUCT based on multiple criteria

Hello,
I wish to make a formula that can sumif based on e.g. if the criteria is "Africa", it will look to the "Countries" tab, determine all of the country (2 letter) acronyms (COL A) that fall under 'Africa' (COL G), and sumif from another tab (MthlyAttr) any cells that fall into those acronyms (COL AZ & COL V). There are a couple of other criteria also (COL C & COL BI).
Please see attached spreadsheet, requiring formulas in the green cells. I believe it may require SUMIFS & SUMPRODUCT combined.
Many thanks!

Thank you very much John. That indeed works but requires that I add a column to one of the source tabs. Might there be a way to accomplish the formula without having to add anything to the source tabs?

I don't know if it can be done any other way ; hopefully someone will provide such a solution.