Sum number range with two sets of criteria listed with merged cells

I took the liberty of adding helper columns to 'Data'. It overcomes problems the merged cells introduce. The formula in D2:E168 is

Formula:

=LOOKUP("zzzzz",A$2:A2)

Then in C1:C4

Formula:

=SUMIFS(Data!C:C,Data!D:D,LOOKUP("zzzzzz",$A$1:A1),Data!E:E,LOOKUP("zzzzzzz",$B$1:B1))

Copy that range and paste into C6, C11 and C16.