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]
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]