Horizontal Sum

[lichfieldluke]

Need to do horizontal sum, (see example data block)

[TABLE="width: 512"]
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl25"]Month1[/TD]
[TD="class: xl25"]Month1[/TD]
[TD="class: xl25"]Month1[/TD]
[TD="class: xl25"]Month1[/TD]
[TD="class: xl25"]Month2[/TD]
[TD="class: xl25"]Month2[/TD]
[TD="class: xl25"]Month2[/TD]
[TD="class: xl25"]Month2[/TD]
[/TR]
[TR]
[TD="class: xl25"]Week 1[/TD]
[TD="class: xl25"]Week 2[/TD]
[TD="class: xl25"]Week 3[/TD]
[TD="class: xl25"]Week 4[/TD]
[TD="class: xl25"]Week 1[/TD]
[TD="class: xl25"]Week 2[/TD]
[TD="class: xl25"]Week 3[/TD]
[TD="class: xl25"]Week 4[/TD]
[/TR]
[TR]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]2[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]5[/TD]
[TD="class: xl24"]5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23"]Month 1[/TD]
[TD="class: xl22"] ? = 8[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="class: xl23"]Month 2[/TD]
[TD="class: xl22"] ? = 20
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
What formula do I use to populate the values of Month 1 and Month 2?

 

[smkyle]

=sumif(A2:H2),"Month1",A3:H3)

if Month 1 is in the same format, then you could do

=sumif($A$2,$H$2,A5,$A$3:$H$3) and copy down