Sum across columns based on criteria of column label

[Sus Controlling]

[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Jan
[/TD]
[TD]Feb
[/TD]
[TD]Mar
[/TD]
[TD]Apr
[/TD]
[TD]May
[/TD]
[TD]Jun
[/TD]
[TD]Jul
[/TD]
[TD]Aug
[/TD]
[TD]Sep
[/TD]
[TD]Oct
[/TD]
[TD]Nov
[/TD]
[TD]Dec
[/TD]
[TD]Total YTD
[/TD]
[TD]Total YE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]Actual
[/TD]
[TD]FCST
[/TD]
[TD]FCST
[/TD]
[TD]FCST
[/TD]
[TD]FCST
[/TD]
[TD]FCST
[/TD]
[TD]YTD
[/TD]
[TD]All
[/TD]
[/TR]
[TR]
[TD]pt1
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]10
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]15
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]20
[/TD]
[TD]30
[/TD]
[TD]30
[/TD]
[TD]85
[/TD]
[TD]205
[/TD]
[/TR]
[TR]
[TD]pt2
[/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][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]pt3
[/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][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Each month I want the formula for YTD to reflect the new month's actual data. They will load the label "Actual" in the column heading and replace the previously loaded forecast data. I want the formula to automatically be ready to sum accordingly for the Actual values. The spreadsheet is huge and has similar areas where this is needed and I need to avoid the user forgetting to adjust these formulas.

 

[NeonRedSharpie]

=SUMIF($B$2:$M$2,"Actual",$B$3:$M$3)

Where your table starts in A1. Row 2 is the headers and Row 3 is pt1 data.

 

[Domenic]

Assuming that your table starts at A1, try...

N3, copied down:

=SUMIF($B$2:$M$2,"Actual",B3:M3)

Hope this helps!

 

[Sus Controlling]

Thanks! Worked great.

 

[Sus Controlling]

Thanks! Worked great!