On Tue, 28 Oct 2008 05:25:00 -0700, DaveKid
wrote:

Basically..... I have 10,000 columns of data each defined by the month they
are in with the month name November, December etc. I have a list of the
months in a drop down menu which when selected will give the amount of data
for that month. I am trying to give a year to date value which will calculate
the month and the months prior to the month selected but I can not do this.


That is a different question from what you initially posted.

But perhaps you could be a bit more specific as to how things are laid out.

Since you write 10,000 columns, I will assume you have Excel 2007, since
earlier versions only had 256 columns.

Also, how do you define the year in your columns? After all, 10,000 columns,
if each is a separate month, would encompass about 833 years.

Where is your list of months for the drop-down menu? What is the range
location? How are those months named? (i.e. is it a month number, month
abbreviation like J or Jan; the full name like January; a formatted date?)

--ron