Comparing Lists and Sum on Matches

jakeman

Active Member
Joined
Apr 29, 2008
Messages
313
Hello - so I am working with two lists of data that I would like to compare. One list is called PCP_Selections and the other is called PCP_Data. PCP_Selections is a much smaller list and may have anywhere from 1 - 7 names in that list. In the PCP_Data list, there are over 2000 rows and it has two other columns that are relevant to me: Date and Member Total.

What I would like to do is compare the PCP_Selections list to the PCP_Data list and where there is a match on the name, I would then like to sum the Member Totals for a given period of time. So for example, in my PCP_Selections list, I have 5 names and I am interested in seeing what the total number of Members were for Q1 2013.

Hope I explained myself clearly.
 

Excel Facts

Create a Pivot Table on a Map
If your data has zip codes, postal codes, or city names, select the data and use Insert, 3D Map. (Found to right of chart icons).

tybaltlives

Active Member
Joined
Nov 6, 2006
Messages
414
maybe something like this...

<b>Excel 2010</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #BBB"><colgroup><col width="25px" style="background-color: #DAE7F5" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #DAE7F5;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="font-weight: bold;;">PCP_Selections</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="font-weight: bold;;">PCP_Data</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: center;font-style: italic;;">Name</td><td style="text-align: center;border-bottom: 1px solid black;font-style: italic;;">Q1</td><td style="text-align: center;border-bottom: 1px solid black;font-style: italic;;">Q2</td><td style="text-align: center;border-bottom: 1px solid black;font-style: italic;;">Q3</td><td style="text-align: center;border-bottom: 1px solid black;font-style: italic;;">Q4</td><td style="text-align: right;;"></td><td style="text-align: center;font-style: italic;;">Name</td><td style="text-align: center;font-style: italic;;">Date</td><td style="text-align: center;font-style: italic;;">Tot</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="border-right: 1px solid black;;">Name1</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">132</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">175</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">87</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name4</td><td style=";">Q3</td><td style="text-align: right;;">98</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="border-right: 1px solid black;;">Name2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">130</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">162</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">76</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name4</td><td style=";">Q1</td><td style="text-align: right;;">61</td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="border-right: 1px solid black;;">Name3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">64</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">51</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">270</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name4</td><td style=";">Q1</td><td style="text-align: right;;">57</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="border-right: 1px solid black;;">Name4</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">218</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">78</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">172</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name5</td><td style=";">Q4</td><td style="text-align: right;;">91</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="border-right: 1px solid black;;">Name5</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">134</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">87</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">191</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">91</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name4</td><td style=";">Q2</td><td style="text-align: right;;">78</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="border-right: 1px solid black;;">Name6</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">0</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">151</td><td style="text-align: right;border-left: 1px solid black;;"></td><td style=";">Name4</td><td style=";">Q1</td><td style="text-align: right;;">100</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: right;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;;"></td><td style=";">Name1</td><td style=";">Q4</td><td style="text-align: right;;">87</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name6</td><td style=";">Q4</td><td style="text-align: right;;">57</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name2</td><td style=";">Q2</td><td style="text-align: right;;">72</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name6</td><td style=";">Q4</td><td style="text-align: right;;">94</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name3</td><td style=";">Q4</td><td style="text-align: right;;">89</td></tr><tr ><td style="color: #161120;text-align: center;">14</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name2</td><td style=";">Q4</td><td style="text-align: right;;">76</td></tr><tr ><td style="color: #161120;text-align: center;">15</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name3</td><td style=";">Q4</td><td style="text-align: right;;">85</td></tr><tr ><td style="color: #161120;text-align: center;">16</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name3</td><td style=";">Q4</td><td style="text-align: right;;">96</td></tr><tr ><td style="color: #161120;text-align: center;">17</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name4</td><td style=";">Q3</td><td style="text-align: right;;">74</td></tr><tr ><td style="color: #161120;text-align: center;">18</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q3</td><td style="text-align: right;;">67</td></tr><tr ><td style="color: #161120;text-align: center;">19</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name1</td><td style=";">Q3</td><td style="text-align: right;;">81</td></tr><tr ><td style="color: #161120;text-align: center;">20</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q1</td><td style="text-align: right;;">60</td></tr><tr ><td style="color: #161120;text-align: center;">21</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name3</td><td style=";">Q1</td><td style="text-align: right;;">64</td></tr><tr ><td style="color: #161120;text-align: center;">22</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name1</td><td style=";">Q2</td><td style="text-align: right;;">66</td></tr><tr ><td style="color: #161120;text-align: center;">23</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name1</td><td style=";">Q3</td><td style="text-align: right;;">94</td></tr><tr ><td style="color: #161120;text-align: center;">24</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name2</td><td style=";">Q3</td><td style="text-align: right;;">79</td></tr><tr ><td style="color: #161120;text-align: center;">25</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q3</td><td style="text-align: right;;">65</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name2</td><td style=";">Q2</td><td style="text-align: right;;">58</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name3</td><td style=";">Q2</td><td style="text-align: right;;">51</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q2</td><td style="text-align: right;;">87</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name1</td><td style=";">Q2</td><td style="text-align: right;;">66</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q1</td><td style="text-align: right;;">74</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name5</td><td style=";">Q3</td><td style="text-align: right;;">59</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style=";">Name2</td><td style=";">Q3</td><td style="text-align: right;;">83</td></tr></tbody></table><p style="width:3.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #BBB;border-top:none;text-align: center;background-color: #DAE7F5;color: #161120">Sheet1</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #BBB"><thead><tr style=" background-color: #DAE7F5;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B3</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A3,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C3</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A3,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D3</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A3,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E3</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A3,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B4</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A4,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C4</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A4,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D4</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A4,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E4</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A4,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B5</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A5,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C5</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A5,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D5</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A5,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E5</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A5,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B6</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A6,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C6</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A6,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D6</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A6,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E6</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A6,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B7</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A7,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C7</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A7,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D7</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A7,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E7</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A7,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">B8</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A8,(<font color="Red">$H$3:$H$32</font>),B$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">C8</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A8,(<font color="Red">$H$3:$H$32</font>),C$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">D8</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A8,(<font color="Red">$H$3:$H$32</font>),D$2</font>)</td></tr><tr><th width="10px" style=" background-color: #DAE7F5;color: #161120">E8</th><td style="text-align:left">=SUMIFS(<font color="Blue">$I$3:$I$32,(<font color="Red">$G$3:$G$32</font>),$A8,(<font color="Red">$H$3:$H$32</font>),E$2</font>)</td></tr></tbody></table></td></tr></table><br />
 

jakeman

Active Member
Joined
Apr 29, 2008
Messages
313
I think that might work. Gotta check it out. Thanks for the solution, man...I really appreciate that.
 

tybaltlives

Active Member
Joined
Nov 6, 2006
Messages
414
good luck with it. Note that its a single sumifs formula that you can copy throughout your reporting table. So once you set the first formula up its pretty easy. Just note the placement of the $ signs that freeze the cell references.

-R
 

Forum statistics

Threads
1,136,354
Messages
5,675,294
Members
419,559
Latest member
BraytonM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top