BTW - Excel 2003.

I have some data in a table with a column for Jan (column A), Feb (column
B), etc. for Sales in Jan, Feb, etc. In the past, I had array formulas that
added up each month as needed, using an Array Sum, starting with Jan formula
were refer to A$1:A$99. As I copied this formula for Feb, the range I added
up was relative, so changed to B$1:B$99, etc.

Now I am trying to switch to some cleaner Named Ranges, such as Sales_Jan,
Sales_Feb, etc.). My add Array Sum formulas have been changed to use the
Named Ranges. Unformtunately, my formula for Jan uses Sales_Jan, while Feb
formula uses Sales_Feb, etc.

Is there some way I can use named ranges that are more "relative", so when I
copy it to other columns, the range used in the Named Range changes also? I
think this defeats the purpose of a "static" Named Range.

One concept could be to make the Named Range for Sales from $A$1:$K:99, then
add another dimension to the Array Sum to select which Columns I wish to
restrict the Array Sum to.

Perhaps this approach is more complicated than neccessary. Is there
something simpler out there?