formula to summarize info in another table

[Christine365]

I'm using Excel 2003
In my example below I've added the column letters across and row numbers down.

I’m creating a spreadsheet template. Section 1 is populated manually with data (specifically, columns A, B, C, E, G, I, K, M). I would like Section 2, to populate itself. Looking at my example below, I would like a formula for cell B11 that looks at the info in Section 1 and adds all the cells in column H that relate to 2008. Cell B12 would do the same thing but for 2009 info. In my example there are 2 rows for 2008 and 3 rows for 2009 in Section 1; however another example may have 5 rows for 2008 and 2 rows for 2009, etc. as well as several more years. For cell B11 (as well as most of Section 2), instead of manually entering “=H3 + H4”, etc. and adjusting it every time I use this template, I would like it to recognize what cells to add together. I tried using a pivot table, which worked to summarize the data in Section 1 but I couldn't easily use the pivot table data to complete column H in Section 2. Thank you!</SPAN></SPAN>

[TABLE="width: 1013"]
<TBODY>[TR]
[TD][/TD]
[TD]A</SPAN>
[/TD]
[TD]B</SPAN>
[/TD]
[TD]C</SPAN>
[/TD]
[TD]D</SPAN>
[/TD]
[TD]E</SPAN>
[/TD]
[TD]F</SPAN>
[/TD]
[TD]G</SPAN>
[/TD]
[TD]H</SPAN>
[/TD]
[TD]I</SPAN>
[/TD]
[TD]J</SPAN>
[/TD]
[TD]K</SPAN>
[/TD]
[TD]L</SPAN>
[/TD]
[/TR]
[TR]
[TD]1</SPAN>
[/TD]
[TD="colspan: 2"]Section 1</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2</SPAN>
[/TD]
[TD]Year</SPAN>
[/TD]
[TD]From Date</SPAN>
[/TD]
[TD]To Date</SPAN>
[/TD]
[TD]# of days</SPAN>
[/TD]
[TD]hours</SPAN>
[/TD]
[TD]Service</SPAN>
[/TD]
[TD]Amount</SPAN>
[/TD]
[TD="align: right"]Prorated Amount</SPAN>
[/TD]
[TD="align: right"]Rate 1</SPAN>
[/TD]
[TD="align: right"]Prorated Rate 1</SPAN>
[/TD]
[TD]Rate 2</SPAN>
[/TD]
[TD="align: right"]Prorated Rate 2</SPAN>
[/TD]
[/TR]
[TR]
[TD]3</SPAN>
[/TD]
[TD]2008</SPAN>
[/TD]
[TD]2008/12/22</SPAN>
[/TD]
[TD]2008/12/27</SPAN>
[/TD]
[TD]6</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]0.016393</SPAN>
[/TD]
[TD="align: right"]$47,731.00</SPAN>
[/TD]
[TD="align: right"]$782.48</SPAN>
[/TD]
[TD="align: right"]$974.10</SPAN>
[/TD]
[TD="align: right"]$15.97</SPAN>
[/TD]
[TD="align: right"]$1,542.00</SPAN>
[/TD]
[TD="align: right"]$25.28</SPAN>
[/TD]
[/TR]
[TR]
[TD]4</SPAN>
[/TD]
[TD]2008</SPAN>
[/TD]
[TD]2008/12/28</SPAN>
[/TD]
[TD]2008/12/31</SPAN>
[/TD]
[TD]4</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]0.010929</SPAN>
[/TD]
[TD="align: right"]$47,731.00</SPAN>
[/TD]
[TD="align: right"]$521.65</SPAN>
[/TD]
[TD="align: right"]$974.00</SPAN>
[/TD]
[TD="align: right"]$10.64</SPAN>
[/TD]
[TD="align: right"]$1,542.00</SPAN>
[/TD]
[TD="align: right"]$16.85</SPAN>
[/TD]
[/TR]
[TR]
[TD]5</SPAN>
[/TD]
[TD]2009</SPAN>
[/TD]
[TD]2009/01/01</SPAN>
[/TD]
[TD="align: right"]2009/01/31</SPAN>
[/TD]
[TD]31</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]0.084932</SPAN>
[/TD]
[TD="align: right"]$47,731.00</SPAN>
[/TD]
[TD="align: right"]$4,053.87</SPAN>
[/TD]
[TD="align: right"]$1,000.00</SPAN>
[/TD]
[TD="align: right"]$84.93</SPAN>
[/TD]
[TD="align: right"]$1,883.00</SPAN>
[/TD]
[TD="align: right"]$159.93</SPAN>
[/TD]
[/TR]
[TR]
[TD]6</SPAN>
[/TD]
[TD]2009</SPAN>
[/TD]
[TD]2009/02/01</SPAN>
[/TD]
[TD]2009/12/26</SPAN>
[/TD]
[TD]329</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]0.901370</SPAN>
[/TD]
[TD="align: right"]$49,045.00</SPAN>
[/TD]
[TD="align: right"]$44,207.68</SPAN>
[/TD]
[TD="align: right"]$1,000.00</SPAN>
[/TD]
[TD="align: right"]$901.37</SPAN>
[/TD]
[TD="align: right"]$1,883.00</SPAN>
[/TD]
[TD="align: right"]$1,697.28</SPAN>
[/TD]
[/TR]
[TR]
[TD]7</SPAN>
[/TD]
[TD]2009</SPAN>
[/TD]
[TD]2009/12/27</SPAN>
[/TD]
[TD]2009/12/31</SPAN>
[/TD]
[TD]5</SPAN>
[/TD]
[TD]40</SPAN>
[/TD]
[TD]0.013699</SPAN>
[/TD]
[TD="align: right"]$49,045.00</SPAN>
[/TD]
[TD="align: right"]$671.85</SPAN>
[/TD]
[TD="align: right"]$1,000.00</SPAN>
[/TD]
[TD="align: right"]$13.70</SPAN>
[/TD]
[TD="align: right"]$1,883.00</SPAN>
[/TD]
[TD="align: right"]$25.79</SPAN>
[/TD]
[/TR]
[TR]
[TD]8</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9</SPAN>
[/TD]
[TD="colspan: 2"]Section 2</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10</SPAN>
[/TD]
[TD]Year</SPAN>
[/TD]
[TD]Sum of Prorated Amount</SPAN>
[/TD]
[TD]Sum of Rate 1 (column J)</SPAN>
[/TD]
[TD]Sum of Rate 2 (column L)</SPAN>
[/TD]
[TD]Total of Rates</SPAN>
[/TD]
[TD]Total Calculated</SPAN>
[/TD]
[TD]Total from other source used for auditing</SPAN>
[/TD]
[TD="align: right"]Difference between the 2 totals</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11</SPAN>
[/TD]
[TD]2008</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]$0.00</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]12</SPAN>
[/TD]
[TD]2009</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]$0.00</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13</SPAN>
[/TD]
[TD]Total</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD]$0.00</SPAN>
[/TD]
[TD="align: right"]$0.00</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

 

[Weazel]

If I'm understanding correctly then maybe somthing like...

=SUMIF($A$3:$A$7,A11,$H$3:$H$7) in B11

 

[Christine365]

Thank you! It is working exactly the way I wanted. I really appreciate your help!