SUM multiple rows from multiple columns with headers

[AndrewRicoh]

I am developing a monthly tracking sheet that will have additional info added each month.
I need to keep a running Grand Total for each of 3 columns with headers as each months info is added.
Each month will be listed under the same headers.
I am looking for a formula to add the grand total for each month under the specific headers in Grand Total.
ex: each column of TOTAL summed under Grand Total Total
each column of Total BW summed under Grand Total BW
each column of Total Color summed under Grand Total Color
I was thinking that the formula would detect each column listing Total, Total BW, and Total Color and sum it under the Grand Total columns of the same header.

here is a sample of the actual sheet that I am building. Each month I will be adding additional info and need to keep a running Grand Total.
[TABLE="width: 1017"]
<tbody>[TR]
[TD]Total[/TD]
[TD]Total BW[/TD]
[TD]Total Color[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]BW[/TD]
[TD]Color[/TD]
[TD]Total[/TD]
[TD]Total BW[/TD]
[TD]Total Color[/TD]
[TD][/TD]
[TD]Total[/TD]
[TD]Total BW[/TD]
[TD="colspan: 2"]Total Color[/TD]
[TD]Total[/TD]
[TD]Total BW[/TD]
[TD]Total Color[/TD]
[/TR]
[TR]
[TD="colspan: 3"]Grand Total[/TD]
[TD] [/TD]
[TD="colspan: 3"]April[/TD]
[TD="colspan: 3"]May[/TD]
[TD][/TD]
[TD="colspan: 3"]June[/TD]
[TD][/TD]
[TD="colspan: 3"]July[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]639[/TD]
[TD="align: right"]639[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]294[/TD]
[TD="align: right"]294[/TD]
[TD="align: right"]0[/TD]
[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="align: right"]1310[/TD]
[TD="align: right"]1310[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]3226[/TD]
[TD="align: right"]3226[/TD]
[TD="align: right"]0[/TD]
[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="align: right"]41[/TD]
[TD="align: right"]41[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]0[/TD]
[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="align: right"]7256[/TD]
[TD="align: right"]6124[/TD]
[TD="align: right"]1132[/TD]
[TD="align: right"]6268[/TD]
[TD="align: right"]4614[/TD]
[TD="align: right"]1654[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody><colgroup><col span="3"><col><col span="3"><col span="3"><col><col span="3"><col><col span="3"></colgroup>[/TABLE]

 

[Saba Sabaratnam]

Hi Andrew,

I copied your data from Column A to R and put the following formula for calculating running total.

=SUMIFS($E4:$XFD4,$E$2:$XFD$2,A$2).

For April, change BW to Total BW and Color to Total Color.

Let me know how you you go.

Kind regards

Saba