For SUMIFS the dimensions of each range must be identical.
Here it seems you have 2 criteria columns which are 1 column wide therefore your summation range must also be 1 column wide.
You would need to create 2 separate SUMIFS - one for each column of the summation range - this is not ideal obviously
(in fact you would be running 4 SUMIFS - PM x 2, NM x 2)
You may then choose to revert to SUMPRODUCT, perhaps along the lines of:
=SUMPRODUCT(ISNUMBER(MATCH(DXB!A3:A3000,{"PM","NM"},0))*(DXB!C3:C3000=1)*{1,1},DXB!G3:H3000)
the above would handle non-numerics in G3:H3000 (avoids explicit coercion of summation range)
else consider adding a total column which sums G:H and use that in the SUMIFS.
Bookmarks