Sum Every 4th column in a range tied to a control cell

  • Thread starter Thread starter stvn.taylor
  • Start date Start date
S

stvn.taylor

Hello,

Any help with the attached would be much appreciated.

I have a spreadsheet with the months of the year listed in a row
starting in cell C1. However, every month has three columns, “2008”,
“2007” and “Variance”. In addition, I have a drop down box in cell A1
which displays a month of the year.

What I need is a formula that will sum only the 4th column (i.e. the
2008 values) based on the month that is displayed in the drop down
box. For example, if the drop down box shows the month of March than
the formula will sum the 2008 values for January, February and March
only.

All ideas are most welcome.

Thanks,

Steve
 
Need more detail on the layout.
the months of the year listed in a row starting in cell C1.
Click to expand...

Ok, if C1 is January (?) then where is February?
However, every month has three columns, “2008”,
“2007” and “Variance”.
Click to expand...

Ok, where are these located?
sum the 2008 values
Click to expand...

OK, where are these values?

--
Biff
Microsoft Excel MVP


Hello,

Any help with the attached would be much appreciated.

I have a spreadsheet with the months of the year listed in a row
starting in cell C1. However, every month has three columns, “2008”,
“2007” and “Variance”. In addition, I have a drop down box in cell A1
which displays a month of the year.

What I need is a formula that will sum only the 4th column (i.e. the
2008 values) based on the month that is displayed in the drop down
box. For example, if the drop down box shows the month of March than
the formula will sum the 2008 values for January, February and March
only.

All ideas are most welcome.

Thanks,

Steve
 
Back
Top