I am using a spreadsheet with multiple colums for each period of a year and
having problems adding a Year To Date summary. See Below:


Period 1 Columns: "Actual", "Plan", "Variance"
Period 2 Columns: "Actual", "Plan", "Variance"
.....
....
Period 12 Columns: "Actual", "Plan", "Variance"

Summary =
Year To Date Colums: "Actual", "Plan", "Variance"

Is there a formula I can use that would allow me to reference an input cell
to select the current month (i.e. I can input "8" into Cell "A1" ) and the
Year To Date colums would add only columns for P1 to P8?

Any help would be truly appreciated