Sum specific row values for array of stores that belong to a region

[Picasso73]

I'm looking for the most efficient macro to look up a store list that tell me what region each store belongs to and then to sum the values of each row for the list of store to come up with a regional value.

On the attached spreadsheet - Store List tab - indicates which store belongs in what region / district

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl74 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% white; }.xl75 { color: windowtext; font-size: 10pt; font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }.xl76 { color: black; font-size: 10pt; font-weight: 700; text-align: center; border: 0.5pt solid windowtext; }.xl77 { color: black; font-size: 10pt; text-align: center; border: 0.5pt solid windowtext; }.xl78 { color: black; font-size: 10pt; }</style> <table style="border-collapse: collapse; width: 166pt;" border="0" cellpadding="0" cellspacing="0" width="166"> <col style="width: 81pt;" width="81"> <col style="width: 38pt;" width="38"> <col style="width: 47pt;" width="47"> <tbody><tr style="height: 14pt;" height="14"> <td class="xl75" style="height: 14pt; width: 81pt;" height="14" width="81">Store</td> <td class="xl75" style="border-left: medium none; width: 38pt;" width="38">Region</td> <td class="xl75" style="border-left: medium none; width: 47pt;" width="47">District #</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2703</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2724</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2739</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2753</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2932</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">2933</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3810</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3828</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3852</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3853</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3854</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3855</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; border-top: medium none;" height="14">3870</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">1</td> </tr> </tbody></table>
On the Store tab is the frequency of each product

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl74 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% white; }.xl75 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% white; }.xl76 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl77 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(196, 215, 155); }.xl78 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(216, 228, 188); }.xl79 { font-size: 9pt; font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl80 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(196, 215, 155); }.xl81 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(216, 228, 188); }</style> <table style="border-collapse: collapse; width: 618pt;" border="0" cellpadding="0" cellspacing="0" width="618"> <col style="width: 300pt;" width="300"> <col style="width: 53pt;" span="6" width="53"> <tbody><tr style="height: 12pt;" height="12"> <td class="xl76" style="height: 12pt; width: 300pt;" height="12" width="300">STORE</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2703</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2704</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2705</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2706</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2707</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2712</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl77" style="height: 12pt; border-top: medium none;" height="12">TotalSurveys</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl77" style="height: 12pt; border-top: medium none;" height="12">FIMP_4</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">10</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">12</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl78" style="height: 12pt; border-top: medium none;" height="12">FIMP_4_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl77" style="height: 12pt; border-top: medium none;" height="12">FIMP_5</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">12</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">10</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">10</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">6</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl78" style="height: 12pt; border-top: medium none;" height="12">FIMP_5_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl77" style="height: 12pt; border-top: medium none;" height="12">FIMP_6</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">15</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">11</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">6</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">4</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl78" style="height: 12pt; border-top: medium none;" height="12">FIMP_6_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl77" style="height: 12pt; border-top: medium none;" height="12">FIMP_7</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl80" style="border-top: medium none; border-left: medium none;">17</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">25</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">6</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">12</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">8</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">7</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl74" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">0</td> </tr> <tr style="height: 12pt;" height="12"> <td class="xl78" style="height: 12pt; border-top: medium none;" height="12">FIMP_7_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">16</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">34</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">23</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">21</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">9</td> <td class="xl81" style="border-top: medium none; border-left: medium none;">17</td> </tr> </tbody></table>
Output-Region tab needs to sum the values of one row for each store that belongs in that region.

<style>table { }td { padding-top: 1px; padding-right: 1px; padding-left: 1px; color: black; font-size: 11pt; font-weight: 400; font-style: normal; text-decoration: none; font-family: Calibri,sans-serif; vertical-align: bottom; border: medium none; white-space: nowrap; }.xl74 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% white; }.xl75 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% white; }.xl76 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl77 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(196, 215, 155); }.xl78 { font-size: 8pt; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(216, 228, 188); }.xl79 { font-size: 9pt; font-weight: 700; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% yellow; }.xl80 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(196, 215, 155); }.xl81 { font-size: 9pt; text-align: center; border: 0.5pt solid windowtext; background: none repeat scroll 0% 0% rgb(216, 228, 188); }</style> <table style="border-collapse: collapse; width: 406pt;" border="0" cellpadding="0" cellspacing="0" width="406"> <col style="width: 300pt;" width="300"> <col style="width: 53pt;" span="2" width="53"> <tbody><tr style="height: 14pt;" height="14"> <td class="xl76" style="height: 14pt; width: 300pt;" height="14" width="300">STORE</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">1</td> <td class="xl79" style="border-left: medium none; width: 53pt;" width="53">2</td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl77" style="height: 14pt; border-top: medium none;" height="14">TotalSurveys</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl77" style="height: 14pt; border-top: medium none;" height="14">FIMP_4</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl78" style="height: 14pt; border-top: medium none;" height="14">FIMP_4_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl77" style="height: 14pt; border-top: medium none;" height="14">FIMP_5</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl78" style="height: 14pt; border-top: medium none;" height="14">FIMP_5_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl77" style="height: 14pt; border-top: medium none;" height="14">FIMP_6</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl78" style="height: 14pt; border-top: medium none;" height="14">FIMP_6_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl77" style="height: 14pt; border-top: medium none;" height="14">FIMP_7</td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl80" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_5</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_4</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_3</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_2</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl74" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl75" style="border-top: medium none; border-left: medium none;"> </td> </tr> <tr style="height: 14pt;" height="14"> <td class="xl78" style="height: 14pt; border-top: medium none;" height="14">FIMP_7_Total</td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> <td class="xl81" style="border-top: medium none; border-left: medium none;"> </td> </tr> </tbody></table>

Any help would be appreciated

 

[Picasso73]

All I have so far is generating a row at the bottom of the STORE tab that looks up what region that store appears in the on the
Output tab I use a SUMPRODUCT formula... =SUMPRODUCT(1*(STORE!$B$31:$IG$31=B$1),STORE!$B2:$IG2)
There must be a better way

 

[Peter_SSs]

Welcome to the MrExcel board!

Your question is not clear to me. The following might help you get a response. Provide a smaller but better sample by ..

1. Store list tab. Less stores but more representative. Surely your stores are not ALL in Region 1 and District 1?

2. Store tab. You can probably get the same idea across with less rows though that isn't critical.

3. Output-Region tab. Provide the expected results for the (new) sample data. Also provide any further explanation you can about how you (manually) arrived at the results.