Can someone tell me what I'm doing wrong with this formula?

This is what the result should be:

A B D E F G H ! J K Tabular Data 1 2 COVID Long-form field names >> Formulas referring to columns within the same table do NOT need to include the Table name Country Report Code Date Country Name State and County Combined State for Filter Death Count (Deaths) Death New Positive Positive New New Death Spike in Count Cases Count Cases Count Percentage New Deaths 3 Short-form field names >> Use only short-form field names in formulas CC RDate CName STC STE Dths NDths PC NPC NDPer SPND 4 2 2 0 24 2 6 6 0 0 0 0 53 0 1371 105 287 0 0 -1 0 0 0% 0% 0% 0% LW LW LW LW 0 0% LW 0 1 60 0 0 5 5 MNP 6 MNP 7 USA 8 USA 9 USA 10 USA 11 USA 12 USA 13 USA mo 14 USA cue 15 USA ura 16 USA 17 USA 18 USA 19 USA 20 USA 21 USA 28-Aug United States 28-Aug United States 28 Aug United States 28-Aug United States Hottes 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 20 28-Aug United States 20. Hata 28-Aug United States 28-Aug United States 28. Au nited States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States Northern Mariana Islands - Saipan Northern Mariana Islands - Unknown North Carolina - Brunswick North Carolina - Tyrrell North Carolina - Warren North Carolina - Clay North CaronndHer North Carolina - Henderson North Carolina - Madison North Carolina - Martin North Carolina - Caswell North Carolina - Gates M... North Carolina - Stokes North Carolina - Watauga North Carolina - Wilkes North Carolina - Craven North Carolina - Greene North Carolina - Sampson Northern Mariana Islands Northern Mariana Islands North Carolina North Carolina North Carolina North Carolina North Caronne North Carolina worn around North Carolina North Carolina North Carolina North Carolina Mali North Carolina North Carolina North Carolina North Carolina North Carolina North Carolina 1 1 2 2 1 7 . 2 . 2 3 0% 0% 0% 0% 0% 0 0 87 1675 64 325 238 79 325 407 1005 888 388 1591 LW LW LW LW LW LW LW 0 mmmm 0% 0% 0 0 0% 0%. 0 3 0 20 26 3 3 20 0 0 4 4 0% 0% LW LW LW LW LW 0 4 0% 020 L M P Q R S f =INDEX(covid[STC), MATCH(MAXIFS[covid[Dths),covid[CC],"USA"),covid[Oths]) N 0 All formulas and functions on this worksheet (and only on this worksheet) must use structured references. The name of the Excel Table is cov. Spike in New Deaths 3 SPND Statistics Area 4 LW 5 5 6 7 8 LW LW LW Maximum Positive Cases Count': Average 'Positive Cases Count': Sum 'Death Cases Count': World 3,761,391 4,374 496,288 9 LW Note: Refer to this cell as your criteria. 10 11 12" 13 14 15 16 LW LW LW LW LW LW LW W Minimum 'Positive Cases Count': Maximum Positive Cases Count': Average 'Positive Cases Count": Range of Positive New Cases Count": Total 'Death Count': Average 'Death Count': Number of Outliers (>= 75th percentile); Average Number of Deaths in non-Outliers: Average Number of Deaths in Outliers: 'STC' of Highest Outlier County: Death Count of Highest Outlier County: United States 0 238,458 1,859 238,458 181,120 57 26 23,680 17 18 19 20 21 An outlier is defined as equal to, or above, the 75th percentile value for death counts. Average number of deaths in rows that are not outliers in terms of death counts. Average number of deaths counts in rows that are considered outliers in terms of death counts. Use INDEX(), MATCH() & MAXIFSO) Use INDEXO), MATCHO & MAXIFSC) Ohio - Lawrence LW LW LW LW LW LW LW LW LW IW 22 23 24 25 26 E1099 New York - New York City STF Dths NDths PC NPC NDPer 5 48 0 6 181 0 0% 0% 0% 6 0 60 0 SPND LW LW LW LW LW LW 5 0 1 1 149 288 112 0% 0% 0 3 4 0 2 0 0 251 2 LW 0% 0% 0% 0% 41 0 826 3 82 0 3 LW LW LW 89 0 2155 1600 355 5 RDate CName 1084 28-Aug United States 1085 28-Aug United States 1086 28-Aug United States 1087 28-Aug United States 1088 28-Aug United States 1089 28-Aug United States 1090 28-Aug United States 1091 28-Aug United States 1092 28-Aug United States 1093 28-Aug United States 1094 28-Aug United States 1095 28-Aug United States 1096 28-Aug United States 1097 28-Aug United States 1098 28-Aug United States 1099 28-Aug United States 1100 28-Aug United States 1101 28-Aug United States 1102 28-Aug United States 1103 28-Aug United States 1104 28-Aug United States 1105 28-Aug United States 0% STC New York - Lewis New York - Livingston New York - Yates New York - Clinton New York - Oswego New York - Delaware New York - Tompkins New York - Rensselaer New York - Ulster New York - Niagara New York - Chautauqua New York - Onondaga New York - Westchester New York - Erie New York - Nassau New York - New York City Illinois - Hamilton Illinois - Scott Illinois - Ford Illinois - Cumberland Illinois - Johnson Illinois - Mercer 4 0 15 0% LW New York New York New York New York New York New York New York New York New York New York New York New York New York New York New York New York Illinois Illinois Illinois Illinois Illinois Illinois 179 0 15 LW 0% 0% 0 38 1450 605 3847 36862 9713 44503 0 2197 45 53 269 0 0% 0% 0% 0% LW LW MED MED LW LW 23680 0 238107 44 45 1 1 o omo + 70 128 0% 0% 0% 0% 1 LW LW LW 110 mm ... 97 0% LW A B D E F G H ! J K Tabular Data 1 2 COVID Long-form field names >> Formulas referring to columns within the same table do NOT need to include the Table name Country Report Code Date Country Name State and County Combined State for Filter Death Count (Deaths) Death New Positive Positive New New Death Spike in Count Cases Count Cases Count Percentage New Deaths 3 Short-form field names >> Use only short-form field names in formulas CC RDate CName STC STE Dths NDths PC NPC NDPer SPND 4 2 2 0 24 2 6 6 0 0 0 0 53 0 1371 105 287 0 0 -1 0 0 0% 0% 0% 0% LW LW LW LW 0 0% LW 0 1 60 0 0 5 5 MNP 6 MNP 7 USA 8 USA 9 USA 10 USA 11 USA 12 USA 13 USA mo 14 USA cue 15 USA ura 16 USA 17 USA 18 USA 19 USA 20 USA 21 USA 28-Aug United States 28-Aug United States 28 Aug United States 28-Aug United States Hottes 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 20 28-Aug United States 20. Hata 28-Aug United States 28-Aug United States 28. Au nited States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States 28-Aug United States Northern Mariana Islands - Saipan Northern Mariana Islands - Unknown North Carolina - Brunswick North Carolina - Tyrrell North Carolina - Warren North Carolina - Clay North CaronndHer North Carolina - Henderson North Carolina - Madison North Carolina - Martin North Carolina - Caswell North Carolina - Gates M... North Carolina - Stokes North Carolina - Watauga North Carolina - Wilkes North Carolina - Craven North Carolina - Greene North Carolina - Sampson Northern Mariana Islands Northern Mariana Islands North Carolina North Carolina North Carolina North Carolina North Caronne North Carolina worn around North Carolina North Carolina North Carolina North Carolina Mali North Carolina North Carolina North Carolina North Carolina North Carolina North Carolina 1 1 2 2 1 7 . 2 . 2 3 0% 0% 0% 0% 0% 0 0 87 1675 64 325 238 79 325 407 1005 888 388 1591 LW LW LW LW LW LW LW 0 mmmm 0% 0% 0 0 0% 0%. 0 3 0 20 26 3 3 20 0 0 4 4 0% 0% LW LW LW LW LW 0 4 0% 020 L M P Q R S f =INDEX(covid[STC), MATCH(MAXIFS[covid[Dths),covid[CC],"USA"),covid[Oths]) N 0 All formulas and functions on this worksheet (and only on this worksheet) must use structured references. The name of the Excel Table is cov. Spike in New Deaths 3 SPND Statistics Area 4 LW 5 5 6 7 8 LW LW LW Maximum Positive Cases Count': Average 'Positive Cases Count': Sum 'Death Cases Count': World 3,761,391 4,374 496,288 9 LW Note: Refer to this cell as your criteria. 10 11 12" 13 14 15 16 LW LW LW LW LW LW LW W Minimum 'Positive Cases Count': Maximum Positive Cases Count': Average 'Positive Cases Count": Range of Positive New Cases Count": Total 'Death Count': Average 'Death Count': Number of Outliers (>= 75th percentile); Average Number of Deaths in non-Outliers: Average Number of Deaths in Outliers: 'STC' of Highest Outlier County: Death Count of Highest Outlier County: United States 0 238,458 1,859 238,458 181,120 57 26 23,680 17 18 19 20 21 An outlier is defined as equal to, or above, the 75th percentile value for death counts. Average number of deaths in rows that are not outliers in terms of death counts. Average number of deaths counts in rows that are considered outliers in terms of death counts. Use INDEX(), MATCH() & MAXIFSO) Use INDEXO), MATCHO & MAXIFSC) Ohio - Lawrence LW LW LW LW LW LW LW LW LW IW 22 23 24 25 26 E1099 New York - New York City STF Dths NDths PC NPC NDPer 5 48 0 6 181 0 0% 0% 0% 6 0 60 0 SPND LW LW LW LW LW LW 5 0 1 1 149 288 112 0% 0% 0 3 4 0 2 0 0 251 2 LW 0% 0% 0% 0% 41 0 826 3 82 0 3 LW LW LW 89 0 2155 1600 355 5 RDate CName 1084 28-Aug United States 1085 28-Aug United States 1086 28-Aug United States 1087 28-Aug United States 1088 28-Aug United States 1089 28-Aug United States 1090 28-Aug United States 1091 28-Aug United States 1092 28-Aug United States 1093 28-Aug United States 1094 28-Aug United States 1095 28-Aug United States 1096 28-Aug United States 1097 28-Aug United States 1098 28-Aug United States 1099 28-Aug United States 1100 28-Aug United States 1101 28-Aug United States 1102 28-Aug United States 1103 28-Aug United States 1104 28-Aug United States 1105 28-Aug United States 0% STC New York - Lewis New York - Livingston New York - Yates New York - Clinton New York - Oswego New York - Delaware New York - Tompkins New York - Rensselaer New York - Ulster New York - Niagara New York - Chautauqua New York - Onondaga New York - Westchester New York - Erie New York - Nassau New York - New York City Illinois - Hamilton Illinois - Scott Illinois - Ford Illinois - Cumberland Illinois - Johnson Illinois - Mercer 4 0 15 0% LW New York New York New York New York New York New York New York New York New York New York New York New York New York New York New York New York Illinois Illinois Illinois Illinois Illinois Illinois 179 0 15 LW 0% 0% 0 38 1450 605 3847 36862 9713 44503 0 2197 45 53 269 0 0% 0% 0% 0% LW LW MED MED LW LW 23680 0 238107 44 45 1 1 o omo + 70 128 0% 0% 0% 0% 1 LW LW LW 110 mm ... 97 0% LW