I am trying to shorten up some of my formulas and it just isn't working right... wondering if there is a rule I don't know about or if I am just not writing the formula correctly. Here are what is working and what is not working:

Generically Written:

Works:

Formula: copy to clipboard 
=SUM(COUNTIFS(Criteria_Range1, {"Criteria1.1","Criteria1.2","Criteria1.3","Criteria1.4","Criteria1.5","Criteria1.6","Criteria1.7","Criteria1.8"}, Criteria_Range2, Criteria2, Criteria_Range3, Criteria3,  Criteria_Range4, Criteria4))


Formula: copy to clipboard 
=SUM(COUNTIFS(Criteria_Range1, {"Criteria1.1","Criteria1.2","Criteria1.3","Criteria1.4","Criteria1.5","Criteria1.6","Criteria1.7","Criteria1.8"}, Criteria_Range2, Criteria2, Criteria_Range3, Criteria3,  Criteria_Range4, Criteria4))+SUM(COUNTIFS(Criteria_Range1, {"Criteria1.1","Criteria1.2","Criteria1.3","Criteria1.4","Criteria1.5","Criteria1.6","Criteria1.7","Criteria1.8"}, Criteria_Range2, Criteria2, Criteria_Range3, Criteria3,  Criteria_Range5, Criteria5))


Doesn't Work:

Formula: copy to clipboard 
=SUM(COUNTIFS(Criteria_Range1, {"Criteria1.1","Criteria1.2","Criteria1.3","Criteria1.4","Criteria1.5","Criteria1.6","Criteria1.7","Criteria1.8"}, Criteria_Range2, Criteria2, Criteria_Range3, Criteria3,  Criteria_Range4, {"Criteria4.1", "Criteria4.2"}))


Exactly how it is in my workbook:

Working:

Formula: copy to clipboard 
=SUM(COUNTIFS('[CAData.xlsx]CurrYR Crimes'!$G:$G, {"1971","1972","1974","1981","1982","1983","1984","1985"}, '[CAData.xlsx]CurrYR Crimes'!$I:$I, ">="&$C$39, '[CAData.xlsx]CurrYR Crimes'!$I:$I, "<="&$D$39,  '[CAData.xlsx]CurrYR Crimes'!$D:$D, "THEFT"))


Formula: copy to clipboard 
=SUM(COUNTIFS('[CAData.xlsx]CurrYR Crimes'!$G:$G, {"1971","1972","1974","1981","1982","1983","1984","1985"}, '[CAData.xlsx]CurrYR Crimes'!$I:$I, ">="&$C$39, '[CAData.xlsx]CurrYR Crimes'!$I:$I, "<="&$D$39,  '[CAData.xlsx]CurrYR Crimes'!$D:$D, "GTP"))


Formula: copy to clipboard 
=SUM(COUNTIFS('[CAData.xlsx]CurrYR Crimes'!$G:$G, {"1971","1972","1974","1981","1982","1983","1984","1985"}, '[CAData.xlsx]CurrYR Crimes'!$I:$I, ">="&$C$39, '[CAData.xlsx]CurrYR Crimes'!$I:$I, "<="&$D$39,  '[CAData.xlsx]CurrYR Crimes'!$D:$D, "THEFT"))+SUM(COUNTIFS('[CAData.xlsx]CurrYR Crimes'!$G:$G, {"1971","1972","1974","1981","1982","1983","1984","1985"}, '[CAData.xlsx]CurrYR Crimes'!$I:$I, ">="&$C$39, '[CAData.xlsx]CurrYR Crimes'!$I:$I, "<="&$D$39,  '[CAData.xlsx]CurrYR Crimes'!$D:$D, "GTP"))


Not Working:

Formula: copy to clipboard 
=SUM(COUNTIFS('[CAData.xlsx]CurrYR Crimes'!$G:$G, {"1971","1972","1974","1981","1982","1983","1984","1985"}, '[CAData.xlsx]CurrYR Crimes'!$I:$I, ">="&$C$39, '[CAData.xlsx]CurrYR Crimes'!$I:$I, "<="&$D$39,  '[CAData.xlsx]CurrYR Crimes'!$D:$D, {"THEFT","GTP"}))


Is there a reason why a second set of criteria placed in brackets won't work with the SUM/COUNTIFS combination?

Thank you for your help!!