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