What error?

Usually SUMIFS() returns 0 when at least 1 condition is not fulfilled (empty string in my formula, as I included the check for 0's). Possible causes for error I can think of are:
Different lengths of ranges used in SUMIFS() formula (in case you use good old references instead of table syntax);
Wrong names of columns or tables, when you use table syntax.

Trailing space in almost all country names on 2nd sheet would result in empty strings for all such countries returned;

I'm not sure about possibility that job codes are numbers on one sheet, and text on other. In your example file this was not the case - I changed the format only, because some entries were certainly texts.

To convert all job codes to text (do it on both sheets when yo decide for it):
Format the Job Code column as text;
Ino some free column enter the formula
;
Copy the formula up/down, so that every Job Code will be converted;
Copy converted values, and overwrite original job codes with converted ones, using PasteSpecial > Values;
Clear/delete the column where you converted job codes.

For Excel, 1234 and '1234' are different values, and simple formatting is not enough. Until you edit the cell, it preserves old format despite the format you set.