Table Dynamic Sum 2 Criteria

[Big_Dawg]

I have a table with multiple years and rows of data. Each record for each year has the same number of rows (3) and the same number of columns (13). The issue is that some years can have multiple records, with different header rows for each record. I would like to sum the 3rd row of each year based on (criteria 1) in column A which year with a dynamic second criteria 2 that could be different in periods 1 thru 12. Help Help!!!!!

Example

Sum 2012 for 25 = 700

[TABLE="width: 1544"]
<tbody>[TR]
[TD="class: xl92, width: 115"]
[TABLE="width: 838"]
<colgroup><col><col span="12"></colgroup><tbody>[TR]
[TD]Year[/TD]
[TD]Period 1[/TD]
[TD]Period 2[/TD]
[TD]Period 3[/TD]
[TD]Period 4[/TD]
[TD]Period 5[/TD]
[TD]Period 6[/TD]
[TD]Period 7[/TD]
[TD]Period 8[/TD]
[TD]Period 9[/TD]
[TD]Period 10[/TD]
[TD]Period 11[/TD]
[TD]Period 12[/TD]
[/TR]
[TR]
[TD="align: right"]2012D[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]37[/TD]
[/TR]
[TR]
[TD="align: right"] 2012R [/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]2012A[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]700[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[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][/TD]
[/TR]
[TR]
[TD="align: right"]2012D[/TD]
[TD="align: right"]20[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]22[/TD]
[TD="align: right"]23[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]29[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD="align: right"]2012[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[TD]R[/TD]
[/TR]
[TR]
[TD="align: right"]2012A[/TD]
[TD="align: right"]100[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]400[/TD]
[TD="align: right"]500[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]700[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]900[/TD]
[TD="align: right"]1000[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]1200[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 117"][/TD]
[TD="class: xl92, width: 124"][/TD]
[TD="class: xl92, width: 121"][/TD]
[TD="class: xl92, width: 124"][/TD]
[TD="class: xl92, width: 124"][/TD]
[/TR]
</tbody>[/TABLE]