Spreadsheet: 84657d1284679425-sumproduct-index-workaround-samplefile
Sheet: Sheet2

 |  |  |  |  |  |  |  | Metric | Index
 |  |  |  |  |  |  |  | KPI 3
 |  |  |  |  |  |  |  | KPI 1
 |  |  |  |  |  |  |  | KPI 2
 |  |  |  |  |  |  |  | KPI 3
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | KPI 5
 |  |  |  |  |  |  |  | KPI 6
 |  |  |  |  |  |  |  | KPI 7
 |  |  |  |  |  |  |  | KPI 8
 |  |  |  |  |  |  |  | KPI 9
Region | Index |  |  | Source Match index | Region | Metric |  | KPI 10
Kraft Europe |  |  |  | 1 | Global | KPI 1 |  | KPI 11
Global | 1 |  |  | 2 | Global | KPI 2 |  | KPI 12
North America | 2 |  |  | 3 | Global | KPI 3 |  | KPI 13
Kraft Europe | 3 |  |  | 6 | Global | [NAME] |  | KPI 14
Asia Pacific | 4 |  |  | 13 | Global | KPI 5
CEEMA | 5 |  |  | 14 | Global | KPI 6
Latin America | 6 |  |  | 16 | Global | KPI 7
 |  |  |  | 17 | Global | KPI 8
 |  |  |  | 20 | Global | KPI 9
 |  |  |  | 23 | Global | KPI 10
 |  |  |  | 24 | Global | KPI 11
 |  |  |  | 31 | Global | KPI 12
 |  |  |  | 33 | Global | KPI 13
 |  |  |  | 35 | Global | KPI 14
 |  |  |  | 36 | North America | KPI 1
 |  |  |  | 37 | North America | KPI 2
 |  |  |  | 38 | North America | KPI 3
 |  |  |  | 41 | North America | [NAME]
 |  |  |  | 48 | North America | KPI 5
 |  |  |  | 49 | North America | KPI 6
 |  |  |  | 60 | North America | KPI 7
 |  |  |  | 61 | North America | KPI 8
 |  |  |  | 64 | North America | KPI 9
 |  |  |  | 67 | North America | KPI 10
 |  |  |  | 68 | North America | KPI 11
 |  |  |  | 75 | North America | KPI 12
 |  |  |  | 77 | North America | KPI 13
 |  |  |  | 79 | North America | KPI 14
 |  |  |  | 80 | Kraft Europe | KPI 1
 |  |  |  | 81 | Kraft Europe | KPI 2
 |  |  |  | 82 | Kraft Europe | KPI 3
 |  |  |  | 85 | Kraft Europe | [NAME]
 |  |  |  | 92 | Kraft Europe | KPI 5
 |  |  |  | 93 | Kraft Europe | KPI 6
 |  |  |  | 95 | Kraft Europe | KPI 7
 |  |  |  | 98 | Kraft Europe | KPI 8
 |  |  |  | 101 | Kraft Europe | KPI 9
 |  |  |  | 104 | Kraft Europe | KPI 10
 |  |  |  | 105 | Kraft Europe | KPI 11
 |  |  |  | 112 | Kraft Europe | KPI 12
 |  |  |  | 114 | Kraft Europe | KPI 13
 |  |  |  | 116 | Kraft Europe | KPI 14
 |  |  |  | 117 | Asia Pacific | KPI 1
 |  |  |  | 118 | Asia Pacific | KPI 2
 |  |  |  | 119 | Asia Pacific | KPI 3
 |  |  |  | 122 | Asia Pacific | [NAME]
 |  |  |  | 129 | Asia Pacific | KPI 5
 |  |  |  | 130 | Asia Pacific | KPI 6
 |  |  |  | 132 | Asia Pacific | KPI 7
 |  |  |  | 133 | Asia Pacific | KPI 8
 |  |  |  | 136 | Asia Pacific | KPI 9
 |  |  |  | 139 | Asia Pacific | KPI 10
 |  |  |  | 140 | Asia Pacific | KPI 11
 |  |  |  | 147 | Asia Pacific | KPI 12
 |  |  |  | 149 | Asia Pacific | KPI 13
 |  |  |  | 151 | Asia Pacific | KPI 14
 |  |  |  | 152 | CEEMA | KPI 1
 |  |  |  | 153 | CEEMA | KPI 2
 |  |  |  | 154 | CEEMA | KPI 3
 |  |  |  | 157 | CEEMA | [NAME]
 |  |  |  | 164 | CEEMA | KPI 5
 |  |  |  | 165 | CEEMA | KPI 6
 |  |  |  | 167 | CEEMA | KPI 7
 |  |  |  | 168 | CEEMA | KPI 8
 |  |  |  | 171 | CEEMA | KPI 9
 |  |  |  | 174 | CEEMA | KPI 10
 |  |  |  | 175 | CEEMA | KPI 11
 |  |  |  | 182 | CEEMA | KPI 12
 |  |  |  | 184 | CEEMA | KPI 13
 |  |  |  | 186 | CEEMA | KPI 14
 |  |  |  | 187 | Latin America | KPI 1
 |  |  |  | 188 | Latin America | KPI 2
 |  |  |  | 189 | Latin America | KPI 3
 |  |  |  | 192 | Latin America | [NAME]
 |  |  |  | 199 | Latin America | KPI 5
 |  |  |  | 200 | Latin America | KPI 6
 |  |  |  | 202 | Latin America | KPI 7
 |  |  |  | 203 | Latin America | KPI 8
 |  |  |  | 206 | Latin America | KPI 9
 |  |  |  | 209 | Latin America | KPI 10
 |  |  |  | 210 | Latin America | KPI 11
 |  |  |  | 217 | Latin America | KPI 12
 |  |  |  | 219 | Latin America | KPI 13
 |  |  |  | 221 | Latin America | KPI 14