Sum across columns based on criteria of column label

[Sus Controlling]

Jan

Feb

Mar

Apr

May

Jun

Jul

Aug

Sep

Oct

Nov

Dec

Total YTD

Total YE

Actual

Actual

Actual

Actual

Actual

Actual

Actual

FCST

FCST

FCST

FCST

FCST

YTD

All

pt1

10

10

10

10

15

15

15

20

20

20

30

30

85

205

pt2

pt3

<tbody>
</tbody>

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!