Here is SUMIFS() used on your data.
I defined both dataranges as tables - so all formulas will expand automatically when a new row is added;
I removed spaces from column headers;
On both sheets, I formatted JobCode/Code column as text, as you have some codes as texts;
In country column on 2nd sheet I removed all trailing spaces;
To get at last some test values returned, I changed a couple of job codes on 1st page so, that they have a matching entryes in table on 2nd sheet;
I did rename sheets.
|