SUMPRODUCT and SUMIF with multiple ranges/criteria

I'm attempting to use SUMPRODUCT with SUMIFS to calculate the sum of data based on two different ranges of criteria.

It works with =SUMPRODUCT(SUMIFS($D$2:$D$9,$A$2:$A$9,G2,$B$2:$B$9,$K$2:$K$9)) using only one of the ranges, but when I add the second with =SUMPRODUCT(SUMIFS($D$2:$D$9,$A$2:$A$9,G2,$B$2:$B$9,$K$2:$K$9,$C$2:$C$9,$M$2:$M$9)), it stops working.

That's possibly made no sense whatsoever, so I've put together a quick mock of what I'm doing

In columns A to D, I have a dataset which is sales by country, city and region.

Columns G and H, sum up sales by country, depending on the parameters (cities and regions) listed in columns K and M. As said above, I can get my formula in column H to work with K, but when I add M, it stops working

Any ideas?

Thanks for responding. But say I wanted to list North, South and West in column M?

Hah! What can I say? I’ve managed to find answers to all my questions over the past six/seven years.